Ed,

Here is an example of my problem

select * from contacts where &pcFilterString into table c:\temp\foundit
or
set filter to contacts=&pcFilterString
run slow with following value

pcFilterString='UPPER(NLAST)="SMITH" AND UPPER(NFIRST)="JOHN"'

The table is indexed on UPPER(NLAST AND UPPER(NFIRST) and the query runs quickly with the values instead of the macro substitution


Your insight is appreciated !