Hi Ric,
>>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.
>

The binary field in SQL Server could be from 1 to 8,000 characters long and store any binary data. It's impossible to conver it to number w/o knowing it's format.