title: Get the values which is not present in table?
body: <p>I have table <code>IteamMaster</code> and query as below,</p>
  
  <pre><code> Select ItemID from ItemMaster 
   Where ItemID IN(1,2,...,100)
  </code></pre>
  
  <p>this query returns me the all the values from the table which are available now what i want is 
  the query should return the itemID which are not present in the table that is suppose My table has data as </p>
  
  <pre><code>  ItemId        ItemName
     1               x
     3               y
     4               z
     10              a
  </code></pre>
  
  <p>then it must return me the all the item id's except 1,3,4,10 from set of <code>IN()</code> conditions value ? How to get that values any help would be great ? 
  And my values are dynamically generating and pass to the query query is also dynamically genrated </p>