title: Extract XML value from SQL column
body: <p>I have a column with content that resembles XML. </p>
  
  <p>An example of the XML is below:</p>
  
  <pre><code>&lt;AlertParameters&gt;
      &lt;AlertParameter1&gt;Database drive C: is below critical threshold on space for last 00:15:00.
  Note: Data may be stale. To get current data, run: Get-ServerHealth -Identity 'Serverxx' -HealthSet 'MailboxSpace'
  Note: Subsequent detected alerts are suppressed until the health set is healthy again.
      &lt;/AlertParameter1&gt;
      &lt;AlertParameter2&gt;http://technet.microsoft.com/en-us/library/ms.exch.scom.MailboxSpace(EXCHG.150).aspx?v=15.0.847.32
      &lt;/AlertParameter2&gt;
      &lt;AlertParameter3&gt;MailboxSpace health set unhealthy (StorageLogicalDriveSpaceMonitor/C:) - Exchange Server Alert: Database drive C: is below critical threshold on space for last 00:15:00.
      &lt;/AlertParameter3&gt;
  &lt;/AlertParameters&gt;
  </code></pre>
  
  <p>I need to extract the value between the <code>AlertParameter3</code> tags. I've tried the value function, but cannot get it to work. I get an error i.e: </p>
  
  <blockquote>
    <p>Cannot find either column "AlertParams" or the user-defined function or aggregate "AlertParams.Value", or the name is ambiguous.</p>
  </blockquote>
  
  <p>All the examples I see involve either specifying the XML namespace or declaring the XML text. How can I extract this data from the column if I need to do a select on the column and do not have a namespace?</p>
  
  <p>Any assistance will be much appreciated!</p>