cTableName = alltrim(ThisForm.ComboBoxName.DisplayValue)
cVariable = '%' + alltrim(upper(ThisForm.ControlName.Value)) + '%'
select fields from (cTableName) where upper(somevalue) like ?cVariable order by somefield

This will be optimized as long as you have an INDEX ON UPPER(SOMEVALUE) tag. I leave it to you to determine what fields to select.

>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