title: Concatenate '$' with numeric value
body: <p>The SelectCommand for my GridView is as follows:</p>
  
  <pre><code>SELECT
    pubName AS Publication,
    COUNT(*) AS Total,
    SUM(CAST (price as INT)) AS Price 
  FROM [SecureOrders]
  WHERE DateTime &gt;= DATEADD(day, -1, GETDATE())
  GROUP BY pubName
  </code></pre>
  
  <p>Where I'm doing the SUM AS Price bit, I want to add a dollar sign ($) to the start, so my data displays as $109, instead of just 109. I tried just doing '$' + SUM, but of course that didn't work. Is there a way around this?</p>