I had this problem a couple years ago with SQL Server 6.5. Today, it seems to be doing the same thing for an ORACLE database and the ODBC driver. The database table field is a NUMER(9,2). The query works for values such as 100 or 100.00 but it fails for values such as 100.01 where the decimal digits are the problem. I debugged the query and decided to seperate the update query into two parts. It works fine now. I find that very strange. There is one field which has a VARCHAR(2000) so it is my guess there is a problem with the ODBC driver under these circumstances. Anyone else had the same problem?