Using wild cards with the IN operator.

[dmaranan]

Does anyone know of a way to use wild cards in an IN operator? I know that you can use it with LIKE. But if you are doing a multiple term search in LIKE and you use % signs, the order affects the outcome. Any suggestions?

 

[sem]

How do you use LIKE with IN?!

 

[karluk]

I don't think you can use "IN" in this situation. I would just code a bunch of "LIKE" conditions separated by "OR". For example

select * from my_table
where col1 like '%ABC%'
or col1 like '%DEF%'
or col1 like '%GHI%';