General information
Category:
Coding, syntax & commands
Title:
Variable in SELECT command
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only