title: How to replace all nonnumeric values?
body: <p><strong>This is TERADATA</strong> (not SQL Server, not Oracle )</p>
  
  <p>I have a column of phone numbers:</p>
  
  <pre><code>(312)9879878
  (298)989-9878
  430-394-2934
  394s9048ds987
  ..........
  </code></pre>
  
  <p>I need to clean this column into</p>
  
  <pre><code>3129879878
  2989899878
  4303942934
  3949048987
  ..........
  </code></pre>
  
  <p>So that only numbers should stay. All other letters, special characters, hyphens ... should be removed. How can I do this?</p>