title: Prepending $ to result SQL Server
body: <p>I am trying to a prepend a <code>$</code> at the beginning of my result using SQL. What is the best way to go about it with it having the same functionality as this line of code has :</p>
  
  <pre><code>CAST(AVG(e.[myAmount]) AS DECIMAL(10,2)) AS 'Total Amount'
  </code></pre>
  
  <p>I know I can do convert it to <code>VARCHAR</code> and add it to beginning of statement, but it then gets rid of my average functionality.</p>