title: Remove HTML from SQL Server column
body: <p>We used to use a WYSIWYG editor and have four text type columns in a SQL Server 2008 R2 table. I would like to remove all the HTML tags. This works when used in an ASP (Classic ASP) page:</p>
  
  <pre><code>Function RemoveHTML(strText )
    Dim RegEx
  
    Set RegEx = New RegExp
  
    RegEx.Pattern = "&lt;[^&gt;]*&gt;"
    RegEx.Global = True
  
    RemoveHTML = RegEx.Replace(strText, "")
  End Function
  </code></pre>
  
  <p>However I would like a different solution perhaps SQL driven. Would very much like some help. Can regular expressions be used in an SQL statement in this way. Any help suggestions would be excellent? I think I would like to keep the break tags but all the rest can go.</p>
  
  <p>TYIA</p>