Adding a Dollar $ to calculation from a CASE statement

You can also use the FORMAT command starting with SQL Server 2012:

SELECT Dollar=FORMAT(123456.78,'c2','en-US'); -- $123,456.78

---

Kalman Toth Database & OLAP Architect SQL Server 2014 Design & Programming

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012