title: Search for multiple values in xml column in SQL
body: <p>This is my table</p>
  
  <pre><code>BasketId(int)   BasketName(varchar) BasketFruits(xml)
  1       Gold        &lt;FRUITS&gt;&lt;FID&gt;1&lt;/FID&gt;&lt;FID&gt;2&lt;/FID&gt;&lt;FID&gt;3&lt;/FID&gt;&lt;FID&gt;4&lt;/FID&gt;&lt;FID&gt;5&lt;/FID&gt;&lt;FID&gt;6&lt;/FID&gt;&lt;/FRUITS&gt;
  2       Silver      &lt;FRUITS&gt;&lt;FID&gt;1&lt;/FID&gt;&lt;FID&gt;2&lt;/FID&gt;&lt;FID&gt;3&lt;/FID&gt;&lt;FID&gt;4&lt;/FID&gt;&lt;/FRUITS&gt;
  3       Bronze      &lt;FRUITS&gt;&lt;FID&gt;3&lt;/FID&gt;&lt;FID&gt;4&lt;/FID&gt;&lt;FID&gt;5&lt;/FID&gt;&lt;/FRUITS&gt;
  </code></pre>
  
  <p>I need to search for the basket which has <code>FID</code> values 1 and 3
  so that in this case i would get <strong>Gold</strong> and <strong>Silver</strong></p>
  
  <p>Although i've reached to the result where i can search for a SINGLE FID value like <strong>1</strong>
  using this code:</p>
  
  <pre><code>declare @fruitId varchar(10);
  set @fruitId=1;
  select * from Baskets
  WHERE BasketFruits.exist('//FID/text()[contains(.,sql:variable("@fruitId"))]') = 1
  </code></pre>
  
  <p>HAD it been T-SQL i would have used the <strong>IN Clause</strong> like this</p>
  
  <pre><code>SELECT * FROM Baskets where FID in (1,3)
  </code></pre>
  
  <p>Any help/workaround appreciated...</p>