title: CASE WHEN THEN ELSE change to union?
body: <p>I was wondering if it is possible to change a <code>CASE when then else</code> to a <code>union all</code>, or something like this.</p>
  
  <p>I hope that it is possible ...</p>
  
  <p>example</p>
  
  <pre><code>CASE WHEN(C.Salutation = 'Dhr.' OR C.salutation = 'dhr.')
           THEN 'Meneer'+' '+ISNULL(C.middlename+' ','')+C.Lastname
      WHEN(C.Salutation = 'Mw.' OR C.salutation = 'mw.')
           THEN 'Mevrouw'+' '+ISNULL(C.middlename+' ','')+C.Lastname
      ELSE 'Meneer/Mevrouw '+ISNULL(C.middlename+' ','')+ISNULL(C.Lastname,'') END AS 'K5'
  </code></pre>
  
  <p>i hope you guys can help me out..</p>