title: Error converting varchar to numeric
body: <p>I have an issue with my case statement. Here is an extract from my table structure:</p>
  
  <pre><code>total = decimal(9,2)
  selfrec = decimal(9,2)
  </code></pre>
  
  <p>And here's the CASE statements that's giving me issues:</p>
  
  <pre><code>CASE
      WHEN Invoices.selfrec IS NOT NULL 
      THEN 'Self Reconcilation: ' + Invoices.total + ' - ' + Invoices.selfrec + ' = ' + Invoices.total - Invoices.selfrec ELSE Invoices.total 
  END AS 'total'
  </code></pre>
  
  <p>When selfrec is not null, it seems to try converting the strings such as 'Self Reconcilation:' to numeric, and obviously fails. Why is it doing this?</p>
  
  <p>Thanks.</p>