add currency symbol to result of SQL query

Here is the issue I want to transform the balance (l.slsprice) into dollar signs $. How do I so?

s.ordnbr+l.lineref as copy,
(l.slsprice*(s.qtyord-s.qtycloseship)) as balance
from CAL.DBO.opssosched s (nolock)
join CAL.DBO.opssoline l (nolock) on s.ordnbr=l.ordnbr

The result I am looking for should be:

  • Is it possible to concatenate a string to a sequence value and use as a column default value?
  • Calculate a Running Total in SQL Server
  • SQL Server queries case sensitivity
  • SQL: Update table where column = Multiple Values
  • Using Multiple Data Readers
  • SQL Query to add a new column after an existing column in SQL Server 2005
  • Balance

    One Solution collect form web for “add currency symbol to result of SQL query”

    use format for sql-server 2012+

    format (<field>,'C')
    Select format(23.00,'$#,##0.##')   -- no cents as per comment
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.