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:

  • Bespoke SQL Server 'encoding' sproc - is there a neater way of doing this?
  • Asp.Net SQL Update Statement
  • Execute SQL script from command line
  • Error 0xc0202009 while importing a text file to SQL Server using Microsoft SQL Server Management Studio 17
  • Getting first and last values from contiguous ranges
  • Using a varchar primary key in a status table
  • 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.