>>>I want to scan a table from bottom to top. Currently, I am using a while loop for that. Is there any faster way like scan?
>>>
>>>Thank you,
>>>Ali
>>
>>No, not really. Do while and SCAN are equavalent in speed, AFAIK.
>
>I have not tested this for a few years but SCAN was 15% faster than using a DO WHILE loop.

Interesting. I forgot that SCAN respects the order set on the table...

Also why would we have a speed difference in WHILE LOOP vs. SCAN? It's doing the same, though we need to write more code. I guess internally it uses something different...