>>>Hello everybody,
>>>
>>>I know how to assign a constant to a varbinary field:
>>>
>>>
>>>REPLACE myVbField WITH 2h
>>>
>>>
>>>But the following situation won't work:
>>>
>>>
>>>lnCount = Somefunction()
>>>REPLACE myVbField WITH lnCount
>>>
>>>
>>>Of course i can program a kludge with macro expansion and a NumToHex-function, but is there a 'normal' way? I must have missed something somewhere, and Help doesn't give me answers.
>>>
>>>Hope some of you know the answer.
>>>
>>>Lennert
>>
>>I don't use varbinary fields myself, but AFAIK they should be treated as character fields.
>>REPLACE myVbField WITH transform(lnCount)
>
>Thank you, Tore; you helped me to the right answer:
>
>
>REPLACE myVbField WITH BINTOC(lnCount,"S")
>
>
>Lennert
You're welcome!