title: Parsing XML Element value entirely in SQL form arbitrary string
body: <p>We have log/audits we have compiled over some time that we would like to run some brief reports on. </p>
  
  <p>One of the columns in the logs is JSON, but contains XML. We want to be able to parse out the value of a certain XML tag for each of the rows. So given an arbitrary string such as the following:</p>
  
  <pre><code>{ "XmlData" :"&lt;tag1&gt;&lt;tag2&gt;&lt;TagToParse&gt;234&lt;/TagToParse&gt;&lt;/tag2&gt;&lt;tag1&gt;".....}
  </code></pre>
  
  <p>I would like to run a sql query that return 234 when I give it the tag name <strong>TagToParse</strong></p>
  
  <p>What is the easiest way to do this ENTIRELY in SQL?</p>