I don't think so. Can you post the table DDL?
>What about 1.00 trying to fit into a (1,0) field would that cause this problem? or 0.00?
>
>
>>My guess is that one of values is bigger than the size of column. I'm afraid you'll have to compare each of numeric values to the max size of each column takind in accound the decimal part.
>>
>>>
>>>1526 Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]
>>Arithmetic overflow error converting numeric to data type numeric.
>>>
>>>
--sb--