Sorry, Sergey but i see this many times.

First, using ALLTRIM() make your query not Rushmore optimizable.


This is not true. VFP, if a index exist, optimize ALLTRIM().

CREATE CURSOR aaa (bbb c(10) DEFAULT STR(RECCOUNT()))
FOR i=1 TO 100
APPEND BLANK
NEXT
INDEX ON ALLTRIM(bbb) TAG myTag
SET deleted OFF
SYS(3054,11)
SELECT * from aaa WHERE ALLTRIM(bbb)=='12'