Combining “LIKE” and “IN” for SQL Server

Question

Will it be possible to combine LIKE and IN in a SQL Server-Query?

So, that this query

SELECT * FROM table WHERE column LIKE IN ('Text%', 'Link%', 'Hello%', '%World%')

Finds any of these possible matches:

Text, Textasd, Text hello, Link2, Linkomg, HelloWorld, ThatWorldBusiness

Answer 1

So, the IN statement creates a series of OR statements.

SELECT * FROM table WHERE column IN (1, 2, 3)

Is effectively

 SELECT * FROM table WHERE column = 1 OR column = 2 OR column = 3

And sadly, that's the route you will have to require together with your LIKE statements

SELECT * FROM table

WHERE column LIKE 'Text%' OR column LIKE 'Hello%' OR column LIKE 'That%'

 Interested in SQL ? Check out this SQL Certification by Intellipaat.