title: Regex pattern inside SQL Replace function?
body: <pre><code>SELECT REPLACE('&lt;strong&gt;100&lt;/strong&gt;&lt;b&gt;.00 GB', '%^(^-?\d*\.{0,1}\d+$)%', '');
  </code></pre>
  
  <p>I want to replace any markup between two parts of the number with above regex, but it does not seem to work. I'm not sure if it is regex syntax that's wrong because I tried simpler one such as <code>'%[^0-9]%'</code> just to test but it didn't work either. Does anyone know how can I achieve this?</p>