money data type

is money data type can only store 4 decimal places?
what data type should I use if I want to store more than 4 decimal places?
I use SQL server 2000 editionDid you look at the "decimal" datatype?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"kei" <kei@.discussions.microsoft.com> wrote in message
news:C359CF38-D84A-4B99-8158-55150E573249@.microsoft.com...
> is money data type can only store 4 decimal places?
> what data type should I use if I want to store more than 4 decimal places?
> I use SQL server 2000 edition|||what is the different between decimal and money datatype? will decimal
datatype less accurate?
"Tibor Karaszi" wrote:
> Did you look at the "decimal" datatype?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "kei" <kei@.discussions.microsoft.com> wrote in message
> news:C359CF38-D84A-4B99-8158-55150E573249@.microsoft.com...
> > is money data type can only store 4 decimal places?
> > what data type should I use if I want to store more than 4 decimal places?
> >
> > I use SQL server 2000 edition
>
>|||It depends on what precision and scale you specify. I suggest you start by reading about the decimal
datatype in Books Online and post back here if you after that have further questions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"kei" <kei@.discussions.microsoft.com> wrote in message
news:620A1CE5-B44A-45E8-81D5-2D881FAC9E0E@.microsoft.com...
> what is the different between decimal and money datatype? will decimal
> datatype less accurate?
> "Tibor Karaszi" wrote:
>> Did you look at the "decimal" datatype?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "kei" <kei@.discussions.microsoft.com> wrote in message
>> news:C359CF38-D84A-4B99-8158-55150E573249@.microsoft.com...
>> > is money data type can only store 4 decimal places?
>> > what data type should I use if I want to store more than 4 decimal places?
>> >
>> > I use SQL server 2000 edition
>>