title: T - SQL statement for number ranges
body: <pre><code>Create table temp
  (
  ID nvarchar(50)
  ) 
  </code></pre>
  
  <p>ID contains numeric values prevailing zeros in some cases so it is defined as varchar</p>
  
  <p>How to get values starts with 3555 to 3999 and 8000 to 9999.There is no specific rule that length is always 4. 
  Eg:</p>
  
  <pre><code>3555 
  35688888888888
  3590909
  
  8000
  85805667
  </code></pre>
  
  <p>all of the values are valid and are to be fetched.</p>
  
  <p>Please let me know T- SQL statement for the above scenario</p>