>Tried that, I think the problem might have more to do with the insert into the SQL server, its type is a decimal and the the field in SQL is holding 2 decimal spots, but when I insert or update it loses and rounds. If I do it from query analyzer it works fine. Is there something to do with the insert that might be throwing it off.

David,
You you post your insert code?

Einar