SQL - Combining 'LIKE' and 'IN' operators?

combining the functinality of both

[Argblat]

Is it possible to combine the functionalities of the LIKE operator and the IN operator into one function?

example: (how do I make this concept into a functional query)

Select * from table1 where PhoneNumber IN ("%1234", "%5678");

This query will not return any results becuase, given the syntax, it will search for the literal string "%1234" instead of treating it as a wildcard operator as it would with a LIKE statement

thank you
-Mike

[zCat]

Select * from table1 where PhoneNumber IN ("%1234", "%5678");

You don't say which database you're using (MySQL judging by the double quotes), but with all the usual suspects the simplest, SQL-ish way to do this is with OR:

Select * from table1 where PhoneNumber LIKE "%1234" OR PhoneNumber LIKE "%5678"

If you have further conditions in the where clause, use brackets, e.g.
Select * from table1 where (PhoneNumber LIKE "%1234" OR PhoneNumber LIKE "%5678") AND widget="blue"