Re: Currency Format with Comma Delimination

From: Dan (dannyjoered_at_aol.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 07:33:03 -0700

That works good to put the $ sign in. But is there also a
way to put the commas in?

>-----Original Message-----
>Use CONVERT function to do this.
>
>Try something as:
>
>SELECT '$'+ CONVERT(VARCHAR(50), money_column, 1) AS
column_name
>FROM <table>
>
>
>--
>Vishal Parkar
>vgparkar@yahoo.co.in | vgparkar@hotmail.com
>
>
>.
>