Howdo I format the money field from 206960.8333 to 206,961 in sql.

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

roryp 96873 SSCertifiable Points: 6649 More actions · Answer 1

Not really clear on what you are asking, but

select round(yourField, 0)

from yourTable

???

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

declare @MyMoney money = 206960.8333

select CEILING(@MyMoney) --Always round up to next dollar

, FLOOR(@MyMoney) --Rounds down to next dollar

, ROUND(@MyMoney, 0) --Round but keep as money type with decimals

, CONVERT(int, @MyMoney) --turns it into a whole number and rounds implicitly as an added bonus/annoyance

If what you are after is display formatting that should be handled in the front end.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.