title: Arithmetic overflow error converting numeric to data type varchar
body: <p>So, here's my query: </p>
  
  <pre><code>SELECT '$'
         + CONVERT(VARCHAR (6), Cast(Avg(TotalPrice) AS NUMERIC (6, 2))) AS 'Average Price',
         '$'
         + CONVERT(VARCHAR (6), Cast(Min(TotalPrice) AS NUMERIC (6, 2))) AS 'Minimum Price',
         '$'
         + CONVERT(VARCHAR (6), Cast(Max(TotalPrice) AS NUMERIC (6, 2))) AS 'Maximum Price'
  FROM   Invoice; 
  </code></pre>
  
  <p>The AVG column and the MIN column work fine but the MAX column returns:</p>
  
  <p>"Arithmetic overflow error converting numeric to data type varchar"</p>
  
  <p>And I'm not sure why I get the error.</p>