title: SQL Computed Column Case with Multiple Criteria
body: <p>I'm having trouble using Case statement for multiple criteria, I don't know how to nest another CASE.</p>
  <ul>
  <li><code>DateTime</code> column: <code>Control_OpenDateOwner</code></li>
  <li><code>DateTime</code> column: <code>Control_ClosedDateRev</code></li>
  </ul>
  <p>Computed column:</p>
  <pre><code>(case when [Control_ClosedDateRev] IS NULL then '1' else '0' end)
  </code></pre>
  <p>Trying to I want to calculate when the <code>OPENDATE</code> is greater than 4 Days opened (using <code>today()</code>) and the close date is Null, put a <code>1</code> (open record and has more than 4 days opened or <code>0</code> if the record is closed or less than 4 days opened, I can't get it to work.</p>
  <p>Why?</p>