Would this work for you?

SELECT * ;
  FROM mytable ;
  WHERE < SomeConditions > ;
  INTO CURSOR crsResult

>Hi all
>I have a range of some id numbers from 100001 to 200000 and I want to select from mutable more the 1000 records in row that meet a certain condition
> how to I do this
>
>thanx
>
>bill