>>>>>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...
>>
>>Where clause could be the same: UPPER(last_name)="SMITH", but remember to have index tag on UPPER(last_name), else your SELECT is not optimizable.
>
>
>Not sure what you mean by (else your SELECT is not optimizable)?? and
>Do you use an index tag when using the SELECT SQL?

Not me. Foxpro will use this tag internally.