title: Set variable with multiple values and use IN
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/337704/parameterizing-a-sql-in-clause">Parameterizing a SQL IN clause?</a>  </p>
  </blockquote>
  
  
  
  <p>In SQL Server I'd like to do something to this effect...</p>
  
  <pre><code>DECLARE @Values varchar(1000)
  
  SET @Values = 'A, B, C'
  
  SELECT
    blah
  FROM 
    foo
  WHERE
    myField IN (@Values)
  </code></pre>
  
  <p>Is this possible or how to accomplish this?</p>