>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)