You can use TOP clause

SELECT TOP 1000 id_num ;
  FROM mytable ;
  WHERE NOT used ;
  ORDER BY id_num ;
  INTO CURSOR crsResult

>
>I m sorry for not being clear enough. Let me try to fix it
>I have a table like this
>
>Id_num used
>1 .T.
>2 .F.
>3 .T.
>
>now what I want to get is 1000 continues records that used = .f. . in other words I need a batch of 1000 id numbers that are not used
>
>bill