sql express 2005 float field

[vbgladiator]

Hey,

I have a field called tax in my table which is of type float.
When I save a value of 0.08 for example, it is stored in the table as
0.079999998211860657. Is this normal? Why isn't it stored as 0.08?

Thanks,

[szlamany]

Hey,

I have a field called tax in my table which is of type float.
When I save a value of 0.08 for example, it is stored in the table as
0.079999998211860657. Is this normal? Why isn't it stored as 0.08?

Thanks,

There is a DB section to this forum - btw

MONEY is the proper datatype for "accurate" values that might go to 4 decimal places. FLOATING point datatypes store values the way you have reported - do not use them...