title: How to delete all non-numerical letters in db2
body: <p>I have some data in DATA column (varchar) that looks like this:</p>
  
  <pre><code>Nowshak 7,485 m
  Maja e Korabit (Golem Korab) 2,764 m
  Tahat 3,003 m
  Morro de Moco 2,620 m
  Cerro Aconcagua 6,960 m (located in the northwestern corner of the province of Mendoza)
  Mount Kosciuszko 2,229 m
  Grossglockner 3,798 m
  </code></pre>
  
  <p>What I want is this:</p>
  
  <pre><code>7485
  2764
  3003
  2620
  6960
  2229
  3798
  </code></pre>
  
  <p><strong>Is there a way in IBM DB2 version 9.5 to remove/delete all those non-numeric letters by doing something like this:</strong></p>
  
  <pre><code>SELECT replace(DATA, --somekind of regular expression--, '') FROM TABLE_A
  </code></pre>
  
  <p><strong>or any other ways?</strong></p>
  
  <p>This question follows from <a href="https://stackoverflow.com/questions/596166/how-to-extract-numerical-data-from-sql-result">this question</a>.</p>