Chopped off part of answer should read "where at(upper(entered text),upper(org name)) >0

>Well how about select org#,org name from org where at(upper(,upper(org name)) > 0
>setting up some SQL's to do this for you...
>
>>VFP 6.0
>>
>>I have a 'search' form with a listbox. First, the user picks something from a Combobox with a list of what to search on (via, Org, Name, Person ID, Auth Type), then the code visible the labels/texts accordingly. Once the text(s) are filled in and the 'Find' button is clicked, I want to list the search on the listbox. The trick is I need to do different things as well with different tables.
>>
>>Lets say I want to do a search for Org $ 'Systems', I want to use the ORG table and list only two fields (org # and org name) with any wording included 'systems'.
>>
>>Lets say I want to do a search for Name $ 'Smith', I want to use the PERSON table and list only one field (name) with any wording included 'smith'.
>>
>>Etc...
>>
>>Now, the next thing is how to correspond back to the correct table (index, recno(), ??) and then I do whatever coding thereafter.
>>
>>The first thing that comes in my mind was to use SET FILTER TO but we know it's terrible slow. Anyone have ideas/suggestions to help me get started?
>>
>>Chuck