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.