title: Concatenate the result of multiple case when statement
body: <p>I would like to display a concatenation of multiple string built upon when statement when the condition is met. As follow : </p>
  
  <pre><code>select
  
  case
    when T1.Field is not null then 'T1,' 
    when T2.Field is not null then /*last results*/ + 'T2,' 
    when T3.Field is not null then /*last results*/ + 'T3,'
  end
  
  
  from T1 
  left outer join T2 on ...
  left outer join T3 on ...
  </code></pre>