float (8) data type problem in MS SQL Server table
Posted on 2005-04-20
I am new on the MS SQL Server. There is a problem really bother me. In one of my table, the data type for one column field is assigned to float (8). When I run the Query analyzer, or run the SQL statement through programing (ex. C++), the recordset coming back has been added many zero ramdomly.
For example, if the real data is 25.212 in the table, the recordset I got (or through Query Analyzer) is 25.212000000000001.
Is any guru know how to solve the problem??