CREATE CURSOR test (fld1 C(10), fld2 C(10)) INDEX ON fld1 TAG fld1 INDEX ON DELETED() TAG Deleted lcTxt = "" SYS(3054,11, "lcTxt") SELECT * FROM test ; WHERE fld1 LIKE "A%" ; INTO CURSOR test1 * Results * VFP8 Using index tag Fld1 to rushmore optimize intermediate result Using index tag Deleted to rushmore optimize intermediate result Rushmore optimization level for intermediate result: partial * VFP9 Using index tag Fld1 to rushmore optimize intermediate result Using index tag Deleted to rushmore optimize intermediate result Rushmore optimization level for intermediate result: full>I used SET ANSI OFF in order to use =, but I belive, it makes now everything not generic, since other back-ends use ANSI ON. So, it looks like I have to use LIKE clause if I want to easy switch back-end.