title: Compare items in a SQL column with array
body: <p>I have a SQL server table where I want to query for items on rows which have a value equal to an item in Array. Here's my example:</p>
  
  <pre><code>Column1    Column2    Column3
  -------    -------    -------
  aaa        100        200
  bbb        100        400
  aaa        200        78  
  ccc        200        200
  </code></pre>
  
  <p>And my array:</p>
  
  <pre><code>string[] arr = {"ddd", "aaa", "fff", "bbb"}
  </code></pre>
  
  <p>So, I want to return from SQL rows matching items in the array. my SQL query should return items where column1 matches an item in the array:</p>
  
  <pre><code>Column1    Column2    Column3
  -------    -------    -------
  aaa        100        200
  bbb        100        400
  aaa        200        78  
  </code></pre>
  
  <p>This all in C# by the way. Help will be appreciate.</p>