title: SQL take just the numeric values from a varchar
body: <p>Say i have a few fields like the following:</p>
  
  <pre><code>abd738927
  jaksm234234
  hfk342
  ndma0834
  jon99322
  </code></pre>
  
  <p>Type: varchar.</p>
  
  <p>How do I take just the numeric values from this to display:</p>
  
  <pre><code>738927
  234234
  342
  0834
  99322
  </code></pre>
  
  <p>Have tried substring however the data varies in length, and cast didnt work either due to being unable to convert, any ideas?</p>