1.00 ends up as 0.99 in float(2,2) field

anjanesh · #1 (**permalink**) 11-26-06, 06:37

Hi

I have a Distance filename of float(2,2) type but when I inserted 1.00 it end up with 0.99. Any way to get it exactly 1.00 ?

Thanks

r937 · #2 (**permalink**) 11-26-06, 08:39

yes, there's a real easy way to get 1.00 when you insert 1.00

use DECIMAL(3,2)

anjanesh · #3 (**permalink**) 11-26-06, 08:45

Oh...I thought it was declared as x digits before the decimal followed by y digits after the decimal place.

Thanks

r937 · #4 (**permalink**) 11-26-06, 08:51

no, it is declared as x total digits, y digits after the decimal

but the main thing is, if you want an accurate value, don't use FLOAT