title: How to use LIKE clause with IN caluse in Sql Server?
body: <p>I want to use LIKE clause and IN clause together.
  e.g: Currently my query is - </p>
  
  <pre><code>SELECT 
     * 
  FROM 
     [USER_DETAILS] 
  WHERE 
     [NAME] LIKE 'Dev%' OR 
     [NAME] LIKE 'Deb%' OR 
     ......
     ......
  </code></pre>
  
  <p>How can i use IN clause to achieve this?
  Can someone please help? :)</p>