title: Search XML with a LIKE or similar full search operation
body: <p>I want to search an XML valued column to see if a contains a string.  I don't know the schema, I want to know if the string is contained anywhere at all.  I don't know if XPATH would work in this situation.</p>
  
  <p>The equivalent of</p>
  
  <pre><code>Select s.Name, ts.ValueXML from table t (nolock) 
  join table2 ts (nolock) on t.key_Id = ts.key_Id
  join table3 s (nolock) on ts.key_Id=s.key_Id
  where s.Name like '%Lab%' and ts.ValueXML  like '%PreviewDateRange%'
  </code></pre>
  
  <blockquote>
    <p>ERROR:  Argument data type xml is invalid for argument 1 of like
    function.</p>
  </blockquote>
  
  <p>relevant <code>ts</code> Table columns</p>
  
  <p><code>ValueXml (XML(.), null)</code></p>
  
  <p>The item I'm searching for should be an attribute.  So if the above isn't possible, then anything containing that attribute would be a good alternative.</p>