title: Range type parameter in SQL Server
body: <p>i need a help for my problem.
  I have a value to be stored in table, and the value is a range.</p>
  
  <p>ex:</p>
  
  <pre><code>Category             Value
  -------------------- ---------------------------
  1                    &lt; 70
  2                    &gt; 70 - 90
  3                    &gt; 90 - 100
  4                    &gt; 100 - 120
  5                    &gt; 120
  </code></pre>
  
  <p>so, when i have a value 80, he is in category 2.</p>
  
  <p>ex:</p>
  
  <pre><code>Value                Category
  -------------------- ---------------------------
  80                    2 
  75                    2 
  115                   4 
  50                    1 
  99                    2 
  </code></pre>
  
  <p>How is the easiest way to store this range type parameter in table, and easy to query it?</p>
  
  <p>Thank you in advance</p>