title: Deriving a thousands or hundreds range from a number in T-SQL
body: <p>We have several thousand job numbers stored in a SQL Server database, and I'd like to be able to derive what 1000's or 100's range they fall into for purposes of grouping in a third party application, which is integrated with our jobs list.</p>
  
  <p>How can I extract the 1000's group that each job number would belong to in a column in my query's result set?</p>
  
  <p>Examples:
  I would like for my output to be:</p>
  
  <pre><code>JOB_NUMBER      JOB_GROUP
  678             0-999
  679             0-999
  1517            1000-1999
  2011            2000-2999
  2150            2000-2999
  ...etc.
  </code></pre>