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