Money Data Type Question

Hi All,
I have a few columns that are of a type Money.
My problem is that the data has four decimal places to the right all the
time e.g...
1032.0000
.0000
12.1200
100.100
etc...
How can I set the columns of type Money to only provide two decimal places.
I would think that this would be automatic or what's the difference between
Money and Decimal?
Thanks very much,
John.John Rugo wrote:
> How can I set the columns of type Money to only provide two decimal places
.
> I would think that this would be automatic or what's the difference betwee
n
> Money and Decimal?
money and smallmoney are specialized forms of decimal. As such, the
definition of money states that it has a scale of 4.
If you only want it to have a scale of 2 then you will need to use a
decimal and define it as such.
For more information look at Books Online for decimal.
http://msdn.microsoft.com/library/e..._de-dz_3grn.asp
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/