CREATE TABLE myTable (myfield n(10,0))  && myfield will hold values from 1 to 300
APPEND BLANK
REPLACE myfield WITH 1
for i = 2 TO 300
   APPEND BLANK 
   REPLACE myfield WITH i
endfor

*--Group myfield by the myfield field myrange 1 = 0->9, 2 = 10->24...
SELECT IIF(myfield >= 0 and myfield <=9, 1, ;
  IIF(myfield >=10 and myfield <=24, 2, ;
  IIF(myfield >=25 and myfield <=49, 3, ;
  IIF(myfield >=50 and myfield <=99, 4, ;
  IIF(myfield >=100 and myfield <=249, 5, 6))))) AS MyRange, Myfield ;
 FROM MyTable ;
 INTO CURSOR cTemp1

>I need to create a summary cursor of a loan file. The customer would like the items grouped based on the number of employees the borrowing company has. The groupings are (0 - 9, 10 - 24, 25 - 49, 50 - 99, 100 - 249 and 250 +). Is there a way I can do this with a SQL statement?