title: Selecting values from an array not in a SQL Server table
body: <p>Let's say I have an array of values, (A,B,C,D) and a SQL Server table (<code>table1</code>) with a column (<code>field1</code>).    </p>
  
  <p>What I want to do is construct a query such that each value selected is not found in <code>table1.field1</code>. </p>
  
  <p>For example, if A and D are found in <code>table1.field1</code> then the only values that would be selected would be B and C.     </p>
  
  <p>What would such a query look like?</p>
  
  <p>Thank you,</p>
  
  <p>Elliott</p>