[SOLVED] selecting where field is float

[abs0lut]

I have a big table with many float fields. I can see the fields in the tables filled with information, but when i query the table i get empty sets but not for all values.

 

example: i can see in the table(using query browser)  that there are values 1.25 in a field called fldName, when i query

select * from table where fldName=1.25 i get an empty result set.

 

with integer i get the correct results sets. Could you please help me?

[Barand]

The trouble with floats is that 1.25 may actually be 1.250000000001 or 1.249999999999

 

either use DECIMAL type fields or search the floats allowing for the rounding errors.

 

eg

... WHERE ABS(fldname - 1.25) < 0.00001

 

or

 

... WHERE fldname BETWEEN 1.249999 AND 1.250001

[abs0lut]

thank you