title: Returning any of multiple CASE statements in one column
body: <p>Unless all <code>CASE</code> statements here are True it returns <code>Null</code> for the entire <code>Options</code> column.
  What I cannot figure out is how to return any True <code>CASE</code> statments, ie: If Col2,Col4 is not null then return only those values. I have no idea what else to try, help?</p>
  
  <pre><code>SELECT 
  CASE WHEN Col1 Is Not Null THEN '&lt;li&gt;' + Col1 + '&lt;/li&gt;' END +
  CASE WHEN Col2 Is Not Null THEN '&lt;li&gt;' + Col2 + '&lt;/li&gt;' END +
  CASE WHEN Col3 Is Not Null THEN '&lt;li&gt;' + Col3 + '&lt;/li&gt;' END +
  CASE WHEN Col4 Is Not Null THEN '&lt;li&gt;' + Col4 + '&lt;/li&gt;' END Options
  FROM TABLE
  </code></pre>
  
  <p>Again, the issue is unless all <code>Case</code> statements are found, it returns Null for the <code>Options</code> column.</p>