title: SQL - Replace specific char in a text
body: <p>I am trying to find a way to replace any &quot;Blabla Pro<strong>fessional</strong> Blabla&quot; or &quot;Blabla Pro<strong>fessionnel</strong> Blabla&quot; string value on a SQL query to &quot;Pro&quot; while keeping the &quot;Blabla&quot; values.
  I can't figure it out.
  I tried SUBSTRING function already.</p>