By michelemayaw on 9/1/2019 1:58 PM
Data results that represent money or currency display as unformatted.  In this post I will show how to format the results as currency.

TOOLS:  Microsoft SQL Server Management Studio v17.3; AdventureWorks2008

TASK:  Display unformatted SQL results as currency


The image below shows the unformatted SQL results.


To display the ‘Sales Last Year’ and ‘Sales YTD’ results as currency add the highlighted function to your query.

FORMAT(SalesLastYear, 'C')

FORMAT(SalesYTD , 'C')



Writing SQL Queries: Formatting Numbers as Currency
Writing SQL Queries: Display Line Numbers
Welcome To My Blog