title: Cast sum(column) as varchar
body: <p>I am trying to do the following:</p>
  
  <pre><code>select @revenue = '$' + cast(sum(amount) as varchar)
      from revenue
      where reportId = @reportId
  </code></pre>
  
  <p>But I am getting the error:</p>
  
  <blockquote>
    <p>Syntax error converting the varchar value '$9.83314e+006' to a column
    of data type int.</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>