when i use the type Money in sql server is there a way to round up the zeros???
SqlDbType.Money


rrr

__________________
rrr

I assume you mean you want to change the string presentation - the default is 4 decimal places, since that is the absolute resolution of the money type. You need to perform your own string conversion if you want a different outcome - e.g. either use STR() function in SQL, or use something like ToString("d2") in .net.

brian

brian

The convert() function with VARCHAR in sqlserver is easier to use, btw.