>>>Anybody know the proper syntax for the following SELECT statement, where p_PayeeName is a public variable. As it is now, it isn't searching for the value of the variable.
>>>
>>>SELECT payee_code, payee_name;
>>> FROM wc!payee2;
>>> WHERE payee2.payee_name like '%p_PayeeName%';
>>> ORDER BY payee_name
>>
>>Try using a macro '&varname', varname='%p_payeename%'
>
>Thanks for the help, but what's a macro? Where would I put this?
>
Macro uses '&' -- it goes after the like:
WHERE payee2.payee_name like '&varname';