Is there a combination of "LIKE" and "IN" in SQL?

Answer

There is no combination of LIKE & IN in SQL, much less in TSQL (SQL Server) or PLSQL (Oracle). Part of the reason for that is because Full Text Search (FTS) is the recommended alternative.

Both Oracle and SQL Server FTS implementations support the CONTAINS keyword, but the syntax is still slightly different:

Oracle:

WHERECONTAINS(t.something,'bla OR foo OR batz',1)>0

SQL Server:

WHERECONTAINS(t.something,'"bla*" OR "foo*" OR "batz*"')