>>>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
If you use SEEK(Upper(mValue)), then you have to have your index
expression be UPPER(
|), otherwise the result
will depend on the SET NEAR and SET EXACT settings (I haven't tried
SET COLLATE yet)
Some things are better be left unknown...NOT!!!