Instr function
I have a column 'Group_Cd' with these values in a table
Group_CD
-------------
AB
CD
EF
AB,CD
AB,CD,EF
CD,EF
AB,EF
if I need to search for a particular code that is sent as a parameter, I am able to use instr function and get the records . foe eg.,
select * from table where
instr(group_cd,'AB') >0 -- for AB records
we have a UI where this value is selected. Sometimes they choose AB and CD and EF. In that case Instr is failing if I say instr(group_cd,'AB,CD,EF').
IS there a way to handle this. I can use multiple instr with a OR, but, I think that is not the best way. Any inputs please. Thanks.
Kumar