On 2012-03-21 09:25, Ivy wrote: > [...] > MoneyInStr = myMoney; > > I store this value into a table and found that this value eventually appears > as -2E-6.
And where exactly it appears as -2E-6 and how do you know it's not the tool that you use to check the value that does the rounding? > May I know why it won't get store as -0.00000199868555? I think it actually does. Try to select from the table only the records that have the field (the one you stored the calculated value in) between -0.00000199868556 and -0.00000199868554. If you get a record back, it proves your conclusion wrong. But please, use a tool as generic as possible (I'd suggest isql), i.e. one that won't round your -0.00000199868556 and -0.00000199868554 to -2E-6 ;) regards Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__
