i am in trouble double precision field with subtract operation



field1 is double precision

field2 is double precision



field1's value is 79.69

field2's value is 78.12



when i subtract field2 from field1 with this sql statement

select field1 - field2 from table1

the result is 1,56999999999999



the result must be 1,57



what is the problem





ibrahim bulut

software and database expert

iletisim online ltd.sti.

turkish republic





[Non-text portions of this message have been removed]