title: Query a SQL field for whether it contains any one of multiple values
body: <p>I want to query the rows of SQL column for whether it contains any one of multiple values.</p>
  
  <p>For instance, return rows of a table where its column A contains any of the following words:
  <code>('cow','farmer','milk')</code>.</p>
  
  <p>Easy enough when you know what the words are, but I want to write a sproc where I can feed in any array of strings and if the column A for a certain row contains any of them, it would return the row.</p>
  
  <p>I would want to be able to feed in:</p>
  
  <p><code>('cow','farmer','milk')</code> </p>
  
  <p>or</p>
  
  <p><code>('cow','farmer','steak','yikes')</code> </p>
  
  <p>or</p>
  
  <pre><code>('cow','farmer','three', 'pigs', 'wolf')
  </code></pre>
  
  <p>It must be relatively straightforward, but I cannot for the life of me figure it out.
  I'm on SQL Server 2008</p>