>>PMFJI. The behavior you describe has nothing to do with the range of the numeric data type.
>
>Thanks for the info.
>
>Just a side question:
>From the help I see the numeric field type is stored as 1 to 20 bytes in a table. In memory numeric values are stored as 8 Bytes, I assume then it's simply a double, isn't it?
>
>Bye, Olaf.
You can see this here:
CREATE CURSOR mycursor (vv N(18,6))
INSERT INTO mycursor VALUES (9999999999.999999)
? mycursor.vv , mycursor.vv+0.000001