title: Remove Non Numeric Values Within SQL Select Statement
body: <p>I have a value in a database column VALUE:</p>
  
  <pre><code>C_4327
  </code></pre>
  
  <p>I need to strip the non numeric text from this so that it just leaves the numbers.  I have tried using the REPLACE function within SQL but not I don't want to replace, just strip them out.  I was previously using PHP to do this:</p>
  
  <pre><code>preg_replace("/[^0-9]/","",$row['VALUE']);
  </code></pre>
  
  <p>I'm retrieving the value in a SELECT statement.</p>
  
  <p>Your help would be appreciated.</p>
  
  <p>Thanks in advance</p>