I have a table in my SQL Server db with fields of money datatype. It seems as though SQL Server likes to have 4 decimal places for the money datatype, but is there any way in the settings of this table or that money field to change this to 2? I know how to programmitically trim the last two zeros, just wondering if I can manually set something so I don't have to do this every time I retrieve the money datatypes from the database table.
Thanks in advance! :)
View Complete Post