CLEAR CREATE CURSOR mcur ( F1 C(5) NOT null) INSERT INTO mcur VALUES ('AB!') INSERT INTO mcur VALUES ('AB') INSERT INTO mcur VALUES ('A B') SET EXACT ON sExp='AB' ? 'WITH SCAN',LOOKUP(F1,m.sExp,F1) INDEX ON F1 TAG TAGERR * with index, lookup is optimized, and uses SET EXACT OFF rule ? 'WITH SEEK',LOOKUP(F1,m.sExp,F1)>Hi,
>CLEAR >CREATE CURSOR mcur ( F1 C(5) NOT null) >INSERT INTO mcur VALUES ('AB'+CHR(0)) >INSERT INTO mcur VALUES ('AB') >INSERT INTO mcur VALUES ('A B') >SET EXACT ON >sExp='AB' >? 'WITH SCAN',LOOKUP(F1,m.sExp,F1) >INDEX ON F1 TAG TAGERR >* with index, lookup is optimized, and uses SET EXACT OFF rule >? 'WITH SEEK',LOOKUP(F1,m.sExp,F1) >>