title: SQL Return Null if One Column is Null (Opposite of COALESCE())
body: <p>In advance, I would like to say thanks for the help. This is a great community and I've found many programming answers here.</p>
  
  <p>I have a table with multiple columns, 5 of which contain dates or null.</p>
  
  <p>I would like to write an sql query that essentially coalesces the 5 columns into 1 column, with the condition that if 1 of the five columns contains a "NULL" value, the returned value is null. Essentially the opposite of the coalesce condition of returning the first non-null, I want to return the first null. If none are null, returning the greatest of the 5 dates would be optimal, however I can settle with returning any one of the 5 dates.</p>
  
  <pre><code>    C1         C2          C3        C4        C5
      --         --          --        --        --
   1/1/1991   1/1/1991    1/1/1991  1/1/1991  2/2/1992
     NULL     1/1/1991    1/1/1991  1/1/1991  1/1/1991
  </code></pre>
  
  <p>Query Returns:</p>
  
  <pre><code>    C1
      --
   2/2/1992
     NULL
  </code></pre>
  
  <p>Thank you very much.</p>
  
  <p>(Server is MSSQL2008)</p>