Hi Nick,
Im' not sure if is bug, but you can use this way
INDEX ON LOWER(PADR(cSubject,30)) TAG cNormSub
SELECT * FROM Test WHERE LOWER(PADR(cSubject,30)) = "abc"
MartinaJ
>I seem to be experiencing index problems with a VarChar field, has anyone else ever encountered similar behaviour with this field type.
>
>
>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
>
>
>Then run
>
>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.