Currency Format in SQL

Question

Currency Format in SQL

nguyennd

SSCommitted

Points: 1881
More actions
April 15, 2010 at 2:20 am

#217877

To format $50000 to $50,000. I use a below query:
"SELECT PARSENAME(Convert(varchar,Convert(money,50000),1),2)"
way faster this way ? Pls, help me. Thanks.
http://unitech.vn

Viewing 5 posts - 1 through 4 (of 4 total)

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

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

What reason are you doing it for? Personally, I would always do this sort of thing at the front-end, rather than the DB.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

nguyennd SSCommitted Points: 1881 More actions · Answer 2

I want to select data to out to file. So I do that.

http://unitech.vn

Cadavre SSC-Forever Points: 41690 More actions · Answer 3

Is the file to be loaded later by another application?

If so, I stick with my original assessment - do it in the presentation layer. C#, VB.Net, Java etc, are all going to be much more efficient at this and will allow for regional differences between clients.

If the file is output straight for printing - well, I think the only way to achieve what you're after is what you've already done.

SELECT CONVERT(VARCHAR(15), CONVERT(MONEY, 50000), 1)

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

nguyennd SSCommitted Points: 1881 More actions · Answer 4

@skcadavre

Thanks for help.

I think i will process it in form.

http://unitech.vn