Subject Re: [firebird-support] How to limit FLOAT's precision to .000
Author Gary Benade
> Now the values in these fields are stored with tons of digits after the
> decimal point, like 12.1234567890123
> I do not need and want to avoid this, would like to have not more than
> 3 digits after the decimal point - like 12.123
> How?

Dont use a float, use a numeric instead
ie. numeric(8,3) . the ,3 indicates how many digits can be stored to the
right of the decimal point, and the 8 how many to the left.

HTH
Gary