title: Can someone tell me how to put a $ with numbers?
body: <p>I have a query where I have to use the <code>convert</code> function to return the unitprice as a decimal with 2 digits to the right of the decimal and a $ to the left of the number.</p>
  
  <p>For example : 10 should be $10.00 </p>
  
  <p>Can anyone tell me how do i insert the $? </p>
  
  <p>this is my code so far</p>
  
  <pre><code>SELECT CONVERT(varchar, UnitPrice, 1) AS varchartotal
  FROM dbo.[Order Details]
  </code></pre>