title: Extracting numeric value in teradata
body: <p>I have a column which is varchar data type.Some sample values are like </p>
  
  <pre><code>abc 56 def
  34 ghi
  jkl mno 78
  </code></pre>
  
  <p>I wanted to get the numeric values only, like</p>
  
  <pre><code>56
  34
  78
  </code></pre>
  
  <p>Thanks in advance.</p>