title: SQL - Getting Most Recent Date From Multiple Columns
body: <p>Assume a rowset containing the following</p>
  
  <pre><code>EntryID    Name      DateModified   DateDeleted
  -----------------------------------------------  
  1          Name1     1/2/2003       NULL
  2          Name1     1/3/2005       1/5/2008
  3          Name1     1/3/2006       NULL
  4          Name1     NULL           NULL  
  5          Name1     3/5/2008       NULL
  </code></pre>
  
  <p><em>Clarification:</em></p>
  
  <p>I need a single value - the largest non-null date from BOTH columns. So the largest of all ten cells in this case.</p>