>i hv a table and i want to use SQL to filter out some record by record no.
>example:
>i want to put record number 10 to 20 from table A into cursor B
>can SQL specify the record number that in range 10 to 20 ???


Using RECNO() in a SQL SELECT statement produces unpredictable results. This is documented in Help. This is one more reason to use Primary Keys.