parsing xml using sql server
<p>Needed some help to parse text in Paragraph element in following XML in SQL server.</p>

<pre><code>&lt;FlowDocument PagePadding="5,5,5,5" Name="RTDocument" AllowDrop="True" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"&gt;   
  &lt;Paragraph&gt;Licence Number: 04467&lt;/Paragraph&gt;
  &lt;Paragraph&gt;Licence Number: 3535333&lt;/Paragraph&gt;
&lt;/FlowDocument&gt;
</code></pre>

<p>Please share any queries you may have.</p>

<p>Thank you</p>