"Mike Hammonds" wrote:
>** Reply Requested When Convenient **
>
>What data type is = to money
There is a money datatype, which is now deprecated. You should use
numeric(x,2) instead (where x is large enough to hold all the digits you
will ever need). (Or numeric(x,0) for currencies like Yen or Italian Lire.)
The money datatype was only ever really good for maintaining data in one
currency.
If you want to record foreign currency values, you need at least these
columns:
amount
currency code
exchange rate against, or amount in, reference currency
The third column is needed because exchange rates vary from day to day, so
the value in the reference currency needs to be established and
recorded.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Enter into his gates with thanksgiving, and into his
courts with praise. Be thankful unto him, and bless
his name." Psalms 100:4