Hi Guys, I've been trying to figure this out for a while, I've tried ||'%'|| and the ascii equivalent.
The goal is to make it so that you can enter in a partial value without including a wildcard. The upper is there to make it case insensitive. Here's the syntax I've tried: and ((upper (u.login) like ||'%'|| upper(:Enter_Account_Manager) ||'%'|| or (:Enter_Account_Manager) is null)) Does anyone have any ideas? Thanks. G. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
