Re: float numbers

[mos]

At 03:29 PM 11/17/2006, Ahmad Al-Twaijiry wrote:
>Ho everyone
>
>I have a column in a table defined as float
>
>mynumber float(20,2)
>
>if we say mynumber column in a row is 1000000 ,  when I run this SQL :
>
>UPDATE Table SET mynumber=mynumber-100.15
>
>the mynumber column will be 999900 not 999899.85
>
>what is the problem ?

Ho Ho Ho,

Float only uses 4 bytes and does not have much precision so you'll get 
rounding. Try DOUBLE instead.

Mike