Creating a money field

[khue]

When I create a field of type money, how do I set this field to be only 2 decimal point precision? i.e. 9999.99

 

[foxdev]

You can't; money and smallmoney inherently support four digits of decimal precision.

You can toy with Convert() to convert it for display, though. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[khue]

I have toy around with the Convert() but still get a 4 decimal place precisions. Is there any way around this?

 

[foxdev]

Try using the style of 1, as in this example:

[tt]declare @MyMoney smallmoney
select @MyMoney = $123.45
select convert(char(15), @MyMoney, 1)[/tt]


Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com