I could really use some help ...

I am trying to conditionally select data from a table (ie select * from database where variable like/= etc) ...

is there a way to combine the like and in statements ...

I want to use a "where variable in (data1, data2, data3, etc.) and use wildcards for the entrys ... (ie like '%data1%')

Is this possible?? the alternative is to keep repeating the "where variable like '%data1%' or variable like '%data2%' or ... " I use a whole pile of these and this takes way too long :(

I would appreciate any help!!!