title: Using LIKE with IN / OR in Stored Procedure
body: <p>I am trying to create a stored procedure in SQL Server 2008 where I am trying to replicate a simple query of</p>
  
  <pre><code>SELECT Col1, Col2 
  FROM Table
  WHERE Col1 LIKE 'A%'
      OR Col1 LIKE 'B%'
      OR Col1 LIKE 'C%'
  </code></pre>
  
  <p>as</p>
  
  <pre><code>CREATE PROCEDURE usp_MySP
      @ColValues varchar(100) = NULL
  AS
  SELECT Col1, Col2 
  FROM Table
  WHERE (@ColValues IS NULL OR Col1 LIKE (????))
  </code></pre>
  
  <p>Unable to replace ??. Basically I want to use <strong>LIKE</strong> with <strong>IN</strong> / <strong>OR</strong>. Any help?</p>