>>>>>>If am trying to Set Filter to last_name = "smith".
>>>>>>In the table the last_name = "SMITH".
>>>>>>I do not want to convert lowercase to uppercase,
>>>>>>I want to filter to find "SMITH" from "smith"?
>>>>>>Set Exact Off does not seem to work.
>>>>>
>>>>>SET FILTER to UPPER(last_name)="SMITH"
>>>>Thanks Ed..
>>>>The problem is data I need to set filter on, is in UPPER and
>>>>LOWER case. I need to set filter to accept both.
>>>>
>>>>Inotherwords, I need to set filter for "Smith"
>>>>
>>>>Help???
>>>
>>>It's answered already: SET FILTER to UPPER(last_name)="SMITH"
>>
>>ok... thanks..
>>
>>How would you do the same for a "where" clause?
>
>SET FILTER doesn't have 'where' clause.
ok... Question - there are two ways to filter out records.
1. select...into cursor, then use that cursor for you filter.
2. set filter on some records.
I am picking the first way for now..my "where" clause is a string
I built from a user's "search criteria" off of a form. Now I want to fire off the select and get my new cursor with the records I want to display.
My questions is:
Will the "where" clause search for upper and/or lower case if I only specify in my "where" clause, the field content, which could be upper or lower? If so, how? If I am wrong about "1 and 2" let me know...