Tracy,

The ICASE() would be better.

>

>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?