Thanks Tore I saw my flaw shortly after I posted.
Brain fart.... :)
Thanks again.
>>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).
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville
No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)