title: Check if a value exists in a collection stored in XML data type column
body: <p>I have an XML data type column called "tags".</p>
  
  <p>In that, I am storing a collection, like so:</p>
  
  <pre><code>&lt;ArrayOfString&gt;
      &lt;string&gt;personal&lt;/string&gt;
      &lt;string&gt;travel&lt;/string&gt;
      &lt;string&gt;gadgets&lt;/string&gt;
      &lt;string&gt;parenting&lt;/string&gt;
  &lt;/ArrayOfString&gt;
  </code></pre>
  
  <p>I want to select all the rows, that have one of the values that I am looking for: for example, I want to select all rows in the table that have a tag "travel".</p>
  
  <p>I know that this works, if I know the index of the value I am looking for:</p>
  
  <pre><code>select * from posts
  where tags.value('(/ArrayOfString/string)[1]', 'nvarchar(1000)') = 'travel'
  </code></pre>
  
  <p>but this query works only if the tag "travel" is the 2nd item in the nodes. How do I check if a value exists, irrespective of the position it is in?</p>