Money Datatype - Four Decimal Places...

[Rebies]

It is really annoying that the money and smallmoney datatypes store four decimal places. Is there an easy way to only have it store two decimal places?

Currently I'm converting the datatype every time I use it because my applications only use and need two decimal places (like most everyday things)

Convert(varchar(50), MyOwnPrice, 1) AS MyOwnPrice

Thanks for any advise.

Andrew

 

[tlbroadbent]

You can't change the storage type or format. Formatting for display is the function of the front-end program not the database.

See faq183-3007 - "Why Does SQL Server Display My Data Like That?"
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm