Ho Roland,
Try:
cHexValue = "0000FF"
? EVAL( "0x" + cHexValue )
Cheers,
Houston
>Good Day Everyone!
>
>I have created a remote view to an SQL database that has many binary fields.
>
>I can't seem to get the view to return the numeric value; it only accepts a char binary or memo binary field. The (numeric/integer) field type result in a error. The results of using a char binary type seems to return in a hex value.
>
>I can't seem to find a VFP 6.0 command to convert HEX value ie. "0001DB" into a numeric value ie. 475 (Binary 111011011). I'am using bit compares to determine the meaning of the individual bits of the field.
>
>Does VFP have such a command to convert hex to numeric?
>
>If not, anything available? ie. HtoN(expression) I can do it long hand but a command or function would be a lot cleaner.
>
>
>Thanks,
>Roland...
censored.