>When creating an index i doing this...
>
>INDEX ON UPPER(cfield) TAG TAG1
>
>but I'm not getting the expected result.
>
>when I do SEEK("mykeyvalue"), in lower case, it can't find it. Why... am I not doing something right?
>
>I know the value ("MYKEYVALUE")exist.
>
>TIA
When you ask for rice, don't expect potatoes! :-)
Try SEEK(upper("mykeyvalue")) or SEEK("MYKEYVALUE"). Or change the index expression to lower(cfield).