>>>>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?