How to convert, cast, or add '$' to a decimal SQL SUM()

Question

What's the simple way to add the dollar sign ('$') or currency to a decimal data type on the following query:

SELECT TOP 100000  
        SUM ([dbo].[Entry].[Amount]) AS 'Total Charges'

Thanks for the help!

Answer 1

This is just presenting concern and should be done in application layer.

But SQL Server can do it using FORMAT function:

SELECT FORMAT(SUM ([Amount]), 'c', 'en-US') AS 'Total Charges'
FROM Entry

LiveDemo

Output:

╔═════════════════╗
║  Total Charges  ║
╠═════════════════╣
║ $21.00          ║
╚═════════════════╝

Answer 2

Here is an example using Sql Server 2012

Declare @Currency float = 1500.00

Select Format(@Currency, 'C', 'en-US')

https://msdn.microsoft.com/pt-br/library/hh213505(v=sql.110).aspx