>I know that there is a simple way to handle this type of pull. I want to be able to select three fields out of this customer table that i am accessing through SQL Pass Through. What I am trying to do is grab all the records that have a name like '*smith*' or some kind of wildcard feature. I know if I use a '?lcname' it will pop an input box but it needs the exact value or else it will not find it.
>I know that this has to be something very simple or it just can't be done.
>
>Thanks in advance
>LeRoy
If you are using SQL Server as the back end it would be something like '%smith%'.