How to convert, distinguish or add "$" to decimal SQL SUM ()

Question

What an easy way to add a dollar sign ('$') or currency to a decimal data type with the following query:

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

Thanks for the help!

Answer 1

This is simply a matter of concern and should be done at the application level.

But SQL Server can do this with FORMAT :

 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

Answer 3

If you don't mind the output data type, you can convert the result to varchar and add "$".

 SELECT TOP 100000 '$ ' + convert(varchar(10), SUM ([dbo].[Entry].[Amount])) AS 'Total Charges'