Multiple INSTR check
628020Mar 12 2008 — edited Mar 12 2008Hi,
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