CODEWITHSUNDEEP
sqlsql-server-2000
Deviprasad Das
Deviprasad Das

Reputation: 4353

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

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? :)

Upvotes: 3

Views: 2297

Answers (2)

onedaywhen
onedaywhen

Reputation: 57023

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 + '%';

Upvotes: 1

burnall
burnall

Reputation: 842

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.

Upvotes: 0

Related Questions