Thanks Bonnie.

John

>John,
>
>Likewise, adding the '%' before the qName as well as after will return a record set that contains qName anywhere in the field, not just the beginning. For example, say you're querying a street name for the string '%Red%', it will return records with a street name of 'Alred Ave' as well as 'Redding Street'.
>
>~~Bonnie
>
>>>Before issuing the query...
>>>qName=ALLTRIM(qName)+'%'
>>>