>Hi Ric,
>
>>Good morning Sergey
>>
>>Am I to assume:
>>
>>1) the line '.... TO LEN(lcStr)' should read '....TO LEN(entity_id)'? otherwise, where and what do I define lcStr as?
>
>Yes.
>
>>
>>2) After converting to HEX, I then convert to ASCII?
>>
>
>I don't know because you didn't say in what format data is stored. Is it integer, float number or something else?

I will need to store the original SQL binary data to a numeric (9,0) field.

R

>
>>Cheers,
>>
>>R
>>>Hi Ric,
>>>
>>>To convert binary data to something meaningfull you've to know what is stored there and in what format. To convert it to hexadecimal string.

lcHex = ""
>>>FOR i=1 TO LEN(lcStr)
>>>  lcHex = lcHex + RIGHT(TRANSFORM(ASC(SUBSTR(entity_id, i,1)), "@0"),2)
>>>ENDFOR
>>>? lcHex
>>>

>>>