How to use LIKE clause with IN caluse in Sql Server?

Question

I want to use LIKE clause and IN clause together. e.g: Currently my query is -

SELECT 
   * 
FROM 
   [USER_DETAILS] 
WHERE 
   [NAME] LIKE 'Dev%' OR 
   [NAME] LIKE 'Deb%' OR 
   ......
   ......

How can i use IN clause to achieve this? Can someone please help? :)

Answer 1

Agree with NullUserException - there is no such syntax. "In" is "syntax sugar" for predicate equal. There is no analog for other operations like >, <, so you should use OR.

Answer 2

Put the parameter values in a table, then use a single JOIN condition e.g.

SELECT * 
  FROM [USER_DETAILS] AS U1
       INNER JOIN Params AS P1
          ON U1.[NAME] LIKE P1.param + '%';