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)+'%'
>>