title: SQL Server 2008: how to format the output as a currency
body: <p>I have a query string which returns a value that has several decimal places. I want to format this to a currency $123.45.</p>
  
  <p>Here is the query:  </p>
  
  <pre><code>SELECT COALESCE(SUM(SUBTOTAL),0) 
  FROM dbo.SALESORD_HDR 
  where ORDERDATE = datediff(d,0,getdate()) 
  and STATUS NOT IN (3,6)
  </code></pre>
  
  <p>I want the result in a currency with 2 decimal places.</p>