title: Filter out columns that contain NULL values in SQL
body: <p>I'm working with SQL Server 2008. 
  I have a select statement that always return a single row. I want to wrap it with another select statement that will return the same row but will filter out all of the columns that have null values.
  For example, if the first select statement returned:</p>
  
  <pre><code>C1     C2     C3     C4     C5
  ----------------------------------
  1       2    NULL   NULL     5
  </code></pre>
  
  <p>The second will filter out columns C3 and C4 and I'll get:</p>
  
  <pre><code>C1      C2      C5
  -------------------
  1       2        5
  </code></pre>
  
  <p>Is that possible?</p>
  
  <p>Thank you!</p>