>>>>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)
i use set collate to general as often as i can, but still make my indexes upper(val) to make it easier for someone else to maintain (no one else here uses set collate)