APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wild card search using %

794048Feb 16 2012 — edited Mar 2 2012

I have a question on wild card searches. I am currently doing a like behind the scenes to look for a string inside a string...

However, if the user wants to put in a wild card like 'AP%Report%'... I would like to return all the ones that begin with AP and have Report in them- is that possible using APEX? I currently do not get any records as the % is considered literally. As our users are used to Oracle, we will have users who will key in a % during the search and we need this to work!

Can anyone please help me with this?

Thanks!
Ramya

This post has been answered by Scott Wesley on Mar 2 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2012

Added on Feb 16 2012

#apex-discussions

8 comments

1,550 views