>INDEX ON LOWER(PADR(cSubject,30)) TAG cNormSub > >SELECT * FROM Test WHERE LOWER(PADR(cSubject,30)) = "abc" >>
>>CREATE TABLE Test ( ; >> iTimeId I PRIMARY KEY, ; >> nParentId I, ; >> cSubject V(80), ; >> ) >>ALTER TABLE Test >>INDEX ON DELETED() TAG Deleted >>INDEX ON LOWER(LEFT(cSubject,30)) TAG cNormSub >>>>
>>SELECT * FROM Test WHERE LOWER(LEFT(cSubject,30)) = "abc" >>>>Which not only returns records beginning 'abc' but also includes those where cSubject is blank! From what I can establish issuing a REINDEX appears to cure the problem.