>>IF SEEK(UPPER(first) etc....)
>>Thanks!
>>Bill Clark
>
>Bill,
>
>Sometimes you don't know what case (upper/lower/mixed) the data
>is. By using upper on the seek and what you are seeking will
>provide a better match for records. This way the user doesn't
>have to remember to type in upper case or not.
>
>Larry Koss
>US EPA

But if I use the command SET COLLATE TO "GENERAL" This would allow the user to type in the search or whatever in UPPER and lower case and a match would be found either way, but I have found when setting up a login screen that unless I have trimmed the values in the expression of the index and without useing SET COLLATE TO "GENERAL" then if I type in a user name for example and dont match it exactly then it wont be found. But are you saying the if I use UPPER in a search that it will work?

I'm new to programmng and cunfused if you cant tell

Thanks
Bill Clark