oracle search word in string
- by Atul
I want to search a word in string in ORACLE in which string is comma separated.
Eg. String is ('MF1,MF2,MF3') and now I want to search whether 'MF' exists in that or not.
If I am using instr('MF1,MF2,MF3','MF') it will give wrong result since I want to search Full MF in MF1 or MF2 or MF3.