Skip to Main Content

SQL & PL/SQL

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!

Multiple INSTR check

628020Mar 12 2008 — edited Mar 12 2008
Hi,
I want to search a field to see if it contains the letters 'a', 'b' or 'c'.
If I just wanted to do a search for one of these, its easy:

select instr(fieldA,'a') from tableA

However, I don't know how to do something like the following:

select instr(fieldA,'a','b','c') from tableA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2008
Added on Mar 12 2008
10 comments
2,898 views