Hi Sergey,

Only WHILE clause it implies scope REST

SELECT payroll_tbl
SET ORDER TO ID DESC
SCAN ALL WHILE unemp_ins_pct = 0
ENDSCAN
.q1 = unemp_ins_pct

The strange is this:

LOCATE is the native VFP search command, but often it is slow.
If it uses a index on FOR clause, it is much slower.

Fabio