title: Case statement that adds column values
body: <p>I need to write a case statement that will return</p>
  
  <pre><code>“1 of 3” if someone voted in one of three elections, 
  “2 of 3” if someone voted in two of three elections, 
  “3 of 3” if someone voted in three of three elections, 
  </code></pre>
  
  <p>The problem is that some of the values are a varchar and some are null and I cannot add them together.
  This is my idea but I cannot get it to work.</p>
  
  <pre><code>select 
  id,
  CASE 
       WHEN race1 + race2 + race3 = 0 then '0-3'
       WHEN race1 + race2 + race3 = 1 then '1-3'
       WHEN race1 + race2 + race3 = 2 then '2-3'
       WHEN race1 + race2 + race3 = 3 then '3-3'
       WHEN race1 + race2 + race3 is null then 'Unknown'
   END AS General_Turnout
  from test4
  </code></pre>
  
  <p><a href="http://sqlfiddle.com/#!3/cac66/3">http://sqlfiddle.com/#!3/cac66/3</a></p>