title: Use a LIKE statement on SQL Server XML Datatype
body: <p>If you have a varchar field you can easily do <code>SELECT * FROM TABLE WHERE ColumnA LIKE '%Test%'</code> to see if that column contains a certain string.</p>
  
  <p>How do you do that for XML Type?</p>
  
  <p>I have the following which returns only rows that have a 'Text' node but I need to search within that node</p>
  
  <pre><code>select * from WebPageContent where data.exist('/PageContent/Text') = 1
  </code></pre>