>>Try

Select mytable
>>SET ORDER TO
>>SET FILTER TO < your condition >
>>GO BOTTOM
>>SKIP -9
>>COPY REST TO result
>>

>
>Yes, that would work. I thought of that in the first place. It's just that I don't want to use any SET FILTER command. Otherwise, I would have to take care of resetting it after and this may cause some problems on other logics especially if maintained by other developers.

In this case you can open table again

USE mytable again IN 0 ALIAS temp1
Select temp1
* the rest of code
...
USE IN temp1