I have this query: select id, importo, pagato from elenco_scadenze where (importo - pagato) <> 0.00
and this results: ID IMPORTO PAGATO 29 60,0016 60,00 90 569,8344 569,83 If I do this: UPDATE ELENCO_SCADENZE set IMPORTO = CAST(IMPORTO AS DECIMAL(18,2))the result of the query changes but is a mistake because the result must be _no rows_ :
ID IMPORTO PAGATO 29 60,00 60,00 90 569,83 569,83 Why? Thanks. -- Luigi Siciliano --------------------------