representing money

Hi,
What is the best datatype to represent money? I really am in search for
accuracy.
Thanks
Loui Merciecanumeric / decimal and the precission and scale will depend on your necesities.
AMB
"Loui Mercieca" wrote:
> Hi,
> What is the best datatype to represent money? I really am in search for
> accuracy.
> Thanks
> Loui Mercieca
>
>|||You definitely want to stick with a fixed precision data type however which
one really depends on how man significant digits your project requires.
I've used as few as two decimal places to as many as ten based on project
requirements. If MONEY or SMALLMONEY have enough precision for your needs,
then use them. Otherwise, use DECIMAL and specify the level of precision
you need. Searching on 'Data Types' in BOL for more information on each
one.
--
--Brian
(Please reply to the newsgroups only.)
"Loui Mercieca" <loui@.gfi.com> wrote in message
news:e6o2lL$pFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hi,
> What is the best datatype to represent money? I really am in search for
> accuracy.
> Thanks
> Loui Mercieca
>