Using IN and LIKE Operator together Oracle SQL %
Posted on 2008-06-18
I have a text list to use with IN operator - IN ('a','b') yet i need to compare it to a field that might contain the value of a;b so i want to put wild cards in the IN list??? Doesn't seem to work - ie:
WHERE IN ('%a%' , '%b%')
Any other way to achieve this without importing text files to table etc?