What I ended up doing for now is:

*Create a cursor.
SELECT mytable
lnrecno = RECCOUNT() - 100
GO lnrecno
SCAN REST
SCATTER MEMVAR
* INSERT INTO mycursor FROM MEMVAR
ENDSCAN

This greatly improved the speed of getting the last X number of records. The table I am querying contains over a million records. Indexing on RECNO() is the real answer but I cannot take the time to do this now.



>I know there is something else that can be done, if I think of it I will post it
>
>
>>Thanks for the help, I was trying to avoid indexing on recno() but it sounds like I'll have to.
>>