<div>
Try below<br />
<br />
SELECT CONCAT( '$' , REPLACE(CONVERT(varchar(20<wbr />), (CAST(987654321 AS money)), 1), '.00', '') )<br />
<br />
SELECT CONCAT( '$' , FORMAT(CAST(987654321 AS MONEY), N'N', 'en-US') )
</div>


<div>
One more.. if you are using SQL 2012 and above. Easy one.<br />
<br />
SELECT FORMAT(1234567.80, '$##,##0.00')
</div>


<div>
What are you building this for? &nbsp;Reason I ask is because it's a best practice to let the presentation layer handle cosmetic formatting, and the data layer to just store the data. &nbsp; Also, altering the format will convert the number into a character data type, which means you lose the ability to perform math expressions and aggregates like SUM(). <br />
<br />
So .. if this is for a report, I HIGHLY ( *** HIGH - LEE *** ) recommend doing the cosmetic formatting in the report and not the database. <br />
<br />
If this is for exporting to a file, then the above solutions should work for you.
</div>


<div>
I tried putting one of your first 2 solutions in my query and it added a { fn } to that portion of the query. I replaced your '987654321' with my fields and added the CASE statement from the beginning of my original code. Am I missing something? We are using SQL 2008 so we have to go with one of your first solutions.
</div>


<div>
Jim,<br />
I appreciate your comments and I totally understand where you are coming from. This is actually being exported to a file. Otherwise I wouldn't waste doing all this formatting.
</div>


<div>
<div class="content wysiwyg-content">
I've been on a formatting binge today with my query! I need to format this to currency but it also needs to include the comma (eg $2,000.00 instead of $2000.00). Right now I have it formatting as $2000.00 but I want the comma included. How can I tweak this to format it with the comma?<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-28974224-1"><span>CASE WHEN LEFT(dbo.jomast.fjobno, 1) &lt;&gt; 'I' THEN '$' + CONVERT(varchar(20), </span>
<span>                         CONVERT(money, dbo.sorels.funetprice * dbo.sorels.forderqty)) ELSE '0' END AS ExtPrice</span>
</code></pre>
</div>
</div>


I've been on a formatting binge today with my query! I need to format this to currency but it also needs to include the comma (eg $2,000.00 instead of $2000.00). Right now I have it formatting as $2000.00 but I want the comma included. How can I tweak this to format it with the comma?

(CODE)

Format to Currency with Comma in SQL Server Query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.