At 08:33 AM 1/17/2004, Uwe Oeder wrote:

>Is double precision the best field type for money values ?

No. Use numeric (18,x) where x in the numbers of digits after
the decimal marker. When I started worrying about precision,
18 digits would represent the US national debt in milli-lira.
Since then the debt has grown and the lira has gone away, but
the fact remains that 18 digits is quite a lot.


Regards,

Ann
www.ibphoenix.com
We have answers.