I want the last occurrence of LIKE(m.var,memo1), on a 1Millions records table.
CLEAR CREATE CURSOR t2 (f2 M ) RAND(3) FOR K=1 TO 50000 INSERT INTO t2 VALUES (STR(1000000000*RAND())) NEXT var="*4?7*" * like LOCATE m.LastFound=RECCOUNT()+1 SET FILTER TO LIKE(m.var,f2) AND RECNO()<m.LastFound GO BOTTOM m.LastFound=RECNO() ? RECNO(),F2 m.LastFound=RECNO() * like CONTINUE GO BOTTOM m.LastFound=RECNO() ? RECNO(),F2 * like CONTINUE GO BOTTOM m.LastFound=RECNO() ? RECNO(),F2 m.LastFound=RECCOUNT()+1 var="*3?7*" GO BOTTOM m.LastFound=RECNO() ? RECNO(),F2 SET FILTER TO RELEASE LastFound BROWSEIt is simple put this on a class and to widen the operation.