>>>>>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';
>
>Thanks again! I think I'm getting closer! However, now I have another problem. When I use the following, it works fine (finding exact matches only):
>
> WHERE payee2.payee_name like '&pPayeeName';
>
>But when I add percent signs for wildcards (to find matches containing the variable value), like this:
>
> WHERE payee2.payee_name like '%&pPayeeName%';
>
>It doesn't work, even if I type a complete field value, it doesn't find any matching records. The manual states I can user % and _ for wildcards, but doesn't give the syntax.
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)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.