Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
velvettiger
Posting Yak Master
115 Posts |
 Posted - 2008-06-12 : 09:39:38
|
| Hi guys,Presently I have a column which represents the amount of money someone spent and for some reason, the fields are being outputted like this 29.8600.This field is infact suppose to 29.86. Now initially this file was an excel spread sheet and I imported it into sql server 2000 and the datatype is money. What would i use to get the desired field. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 09:41:38
|
| Its coming in the expected manner. Money has a precision of 4 decimal places. If you want it to store only 2 decimal places use Numeric(10,2) or Decimal(10,2) as datatype. |
 |
|
|
|
|
|
Formatting a money field