Remove a <img tag from the table using SQL Server 2012
<p>I am using SQL Server 2012 and my data and image is inserted from a richtextbox from asp.net and I need help to display only text, not image, from the specific field from the table.</p>

<p>Here is an example:-</p>

<pre><code>&lt;p&gt;The Brando is an exquisite luxury resort on French Polynesia&amp;rsquo;s breathtakingly beautiful private atoll of Tetiaroa,
   &lt;img style="width: 100%;" src="../images/InfrastructureImage/The Brando, French Polynesia 2.jpgc05350ab-ba5d-465f-91da-4b9edb8fce47.jpg" 
  alt="The Brando, French Polynesia 2.jpg" /&gt;
&lt;/p&gt;
</code></pre>

<p>into this example I want only text not image which is on the <code>&lt;img&gt;</code> tag I want to remove the complete image tag. I need help fetching only the text.</p>

<p>Please help me with this</p>