Arithmetic overflow error

Hi,

After 6 months running with the datatype decimal(15,2), every time that I want to update a row, the following message is displayed,

Microsoft SQL Server:8115[Microsoft][ODBC SQL Server Driver][SQL
Server]Arithmetic overflow error converting float to data type
numeric

and the decimal data is shift to left, like this sample:

41.61 >> 4161.00
62.30 >> 623.00

Anyone can help?

tksHave you run a dbcc check on the table/database?

Try doing a compare
select * from tbl where fld = 62.3 to find if it is a presentation or data problem (probably it is the data)

What happens if you do
select convert(decimal(15,2),62.3)