title: BETWEEN clause in DATEPART function
body: <p>I want to use BETWEEN clause in this query and don't know how to do this</p>
  
  <pre><code>SELECT * FROM record 
  WHERE  (DATEPART(yy, register_date) = 2009
  AND    DATEPART(mm, register_date) = 10
  AND    DATEPART(dd, register_date) = 10)
  </code></pre>