title: SQL Server query to delete text from text column
body: <p>I have a SQL Server database with a table <code>feedback</code> that contains a text column <code>comment</code>. In that column I have tag data, for example </p>
  
  <pre><code>This is my record &lt;tag&gt;Random characters are here&lt;/tag&gt; with information. 
  </code></pre>
  
  <p>How do I write a query to update all of these records to remove the <code>&lt;tag&gt;&lt;/tag&gt;</code> and all of the text in between?</p>
  
  <p>I'd like to write this to a different 'temporary' table to first verify the changes and then update the original table.</p>
  
  <p>I am running SQL Server 2014 Express.</p>
  
  <p>Thank you</p>