title: SQL using CASE with STRING function
body: <p>I'm trying to write a SQL query that uses CASE and STRING together and getting an error. 
  This is what I'm trying to work on. Any help is greatly appreciated. 
  I tried adding in STRING function as well but also does not work.  </p>
  
  <pre><code>SELECT Case
           when sn.1_code =  1 then 'Attended  -- ' ,  
                                    sn.mult_1 , 
                                    , 'and'  ,  
                                    sn.dict_2 ,  
                                    ' also acted with ' ,  
                                    sn.dict_3 , 
                                    '.' , 
           when sn.1_code =  3 then 'left because ' ,
                                    sn.mult_2 ,
                                    '.' ,
           when sn.dict_1 =  2 then 'Went home' ,
           when sn.dict_1 = 24 then 'Canceled' AS 'Attendance'
  FROM db.sn
  </code></pre>