title: Is it possible to have a CASE WHEN THEN SELECT in a WHERE CLAUSE
body: <p>I was just wondering if it would be possible to have a CASE statement in a WHERE clause exactly in this form...</p>
  
  <pre><code>SELECT *
  FROM TABLEA
  WHERE date between '2014-02-01' and '2014-02-28' and
  CASE
     WHEN date&gt;'2014-02-28' THEN (SELECT FROM TABLEC WHERE...)
     ELSE (SELECT FROM TABLE B WHERE...)
  END
  </code></pre>
  
  <p>Thanks!</p>