<div>
If your field is already a money type, you don't need to cast to money.<br />
<br />
[NewMemo] = CAST(PurchaseOrder.Memo AS Nvarchar(2000)) <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ ' $' <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ CONVERT(nvarchar(20), convert(money, PurchaseOrder.Amount + tax1 + tax2 + tax3), 1) 
</div>


If your field is already a money type, you don't need to cast to money.

[NewMemo] = CAST(PurchaseOrder.Memo AS Nvarchar(2000))
                       + ' $'
                       + CONVERT(nvarchar(20), convert(money, PurchaseOrder.Amount + tax1 + tax2 + tax3), 1)

<div>
Just seconds late...<br />
I see Shannon has already given you the answer. &nbsp;Convert allows you to specify the style, check BOL.
</div>


Just seconds late...
I see Shannon has already given you the answer.  Convert allows you to specify the style, check BOL.

<div>
<div class="content wysiwyg-content">
Hello. &nbsp;I have two fields, one memo and the other currency. &nbsp;I need to concat both fields into a single field but I need the currency format for the PurchaseOrder.Amount to stay intact with comma separators. &nbsp;My current code is shown below. &nbsp;Problem here is the PurchaseOrder.Amount field looses all commas (i.e. $23335561.23)<br />
<br />
Anybody have a relatively simple solution?<br />
<br />
[NewMemo] = CAST(PurchaseOrder.Memo AS Nvarchar(2000)) <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ ' $' <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ CAST((PurchaseOrder.Amount<wbr /> + tax1 + tax2 + tax3) AS nvarchar(20)) <br />

</div>
</div>


Hello.  I have two fields, one memo and the other currency.  I need to concat both fields into a single field but I need the currency format for the PurchaseOrder.Amount to stay intact with comma separators.  My current code is shown below.  Problem here is the PurchaseOrder.Amount field looses all commas (i.e. $23335561.23)

Anybody have a relatively simple solution?

[NewMemo] = CAST(PurchaseOrder.Memo AS Nvarchar(2000)) 
                       + ' $' 
                       + CAST((PurchaseOrder.Amount + tax1 + tax2 + tax3) AS nvarchar(20)) 


T-SQL - Concatenate Memo and Currency

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.