>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%'
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.