title: Concatenate multiple columns in a case statement
body: <p>There is a query in which I have to concatenate 12 columns in a case statement. It would've been easier if it was 2 or 3. To be clearer, here is my query:</p>
  
  <pre><code>SELECT column1 
    ,column2
    ,effet_secondaire_desc = CASE WHEN [symp01] = 'y' THEN 'Pedi apeti'
                                  WHEN [symp02] = 'y' THEN 'Ke plen'
                                  WHEN [symp03] = 'y' THEN 'Zye jon'
                                  WHEN [symp04] = 'y' THEN 'Dyare'
                                  WHEN [symp05] = 'y' THEN 'Ko grate'
                                  WHEN [symp06] = 'y' THEN 'Lafyev ak frison'
                                  WHEN [symp07] = 'y' THEN 'Ko fe mal ak jwenti fe mal'
                                  WHEN [symp08] = 'y' THEN 'Pikotman'
                                  WHEN [symp09] = 'y' THEN 'Fatig'
                                  WHEN [symp10] = 'y' THEN 'Tet vire/vetij'
                                  WHEN [symp11] = 'y' THEN 'Vant fe mal'
                                  WHEN [symp12] = 'y' THEN [symp12_desc] 
                                  ELSE '~'
                              END
               .....
               ,columnx
  FROM MyTable
  </code></pre>
  
  <p>[symp01] ... [symp12] are the 12 columns I want to concatenate. So the value of effet_secondaire_desc should be something like this 'Pedi apeti, Ko grate, Lafyev ak frison, ...'. </p>
  
  <p>Can anyone help me with this please?
  Thanks in advance.</p>