title: SQL query using Like and Between in the same statement
body: <p>so here is my problem I need to select records in between year 2000-2008 but the columns I need to search for is in type varchar example:</p>
  
  <pre><code>IntRecordID     VARCHARYear
      1            1990-2000
      2            2001-2005
      3            2005-2006
      4            2007-2008
      5            2009-2020
  </code></pre>
  
  <p>select all record id that has VARCHARYear between 2000 and 2008</p>
  
  <pre><code>IntRecordID
      2
      3
      4
  </code></pre>
  
  <p>what is the sql query that I need to achieve this?</p>