title: SQL: case clause in Where clause
body: <p>I am trying to write a query where i need to show the values that have either start date more than a year ago or start date = Null.</p>
  <p>I have done &quot;more than a year ago&quot; part but i am not sure how to consolidate it with start date = null</p>
  <p>do i need to use case statement?</p>
  <pre><code>Select
      T0.JOBID
    , T0.JOBTITLE
    , T0.STATUS
    , T0.STARTDATE
    , T0.ENTEREDDATE
  From
      ENPRISE_JOBCOST_JOB T0
  Where
      T0.STATUS Not In (7, 8) AND
      T0.STARTDATE &lt;= DATEADD(YEAR, -1, GETDATE())
  </code></pre>