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 ==--__
__--==============================--__