Hi Fabio,
You're correct but I would rather do this way because LOCATE is Rushmore optimizable.

SELECT payroll_tbl
SET ORDER TO ID DESC
LOCATE   && GO TO TOP
SCAN WHILE unemp_ins_pct = 0
ENDSCAN

>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