>Assign the percent signs to the variable before the SQL code like I did above with varname='%p_payeename%' then use '&varname' in the SQL...(or whatever name you want to use, like p_payeename)

It works! Thanks again (and again, and again...)

I had to add an ampersand to varname='%&p_payeename%' and TRIM() my value from the text box.

Jeff