I have a field of type Real in my SQL 2K database. I stored a value of
..35 in the field.
When I "Open Table"->"Return All Rows" in the Enterprise Manager I get
back .35 for the field value.
I went to The SQL Query Analyzer and executed the following T-SQL:
SELECT field
FROM table
I got back 0.34999999 for the field.
When running stored procs against the field I also get back 0.34999999.
This is causing problems in my app. I can use the Round T-SQL
statement to get back the value I expect, but this causes app
development problems. For a goof I put 1.35 in the field and T-SQL did
return 1.35. This problem only seems to occur with 0.nnn values. I
also tried a float data type for the field but I had the same problems
I had with real.
Why is T-SQL returning 0.34999999 for my field?