Like Operator and % wildcard
532347Sep 6 2006 — edited Sep 6 2006Hi,
I am having some trouble with an Application Express Report. I am using the 'Pl/sql returning a sql query' as the source for my reports region. I am searching for records based on first name using the following condition:
w := ' UPPER(FIRST_NAME) LIKE UPPER(:P31_FIRST_NAME)||"%" ';
when I try to query entering the first_name I get the following:
failed to parse SQL query:
ORA-00904: "%": invalid identifier
I figure I may not have the syntax exactly right for the wildcard. Can anyone see where I am going wrong?
Thanks,
Una.