title: Strip out non-numeric characters in SELECT
body: <p>In an MS Access 2007 project report, I have the following (redacted) query:</p>
  
  <pre><code>SELECT SomeCol FROM SomeTable
  </code></pre>
  
  <p>The problem is, that <code>SomeCol</code> apparently contains some invisible characters. For example, I see one result returned as <code>123456</code> but <code>SELECT LEN(SomeCol)</code> returns <code>7</code>. When I copy the result to Notepad++, it shows as <code>?123456</code>.</p>
  
  <p>The column is set to <code>TEXT</code>. I have no control over this data type, so I can't change it.</p>
  
  <p>How can I modify my <code>SELECT</code> query to strip out anything non-numeric. I suspect RegEx is the way to go... alternatively, is there a <code>CAST</code> or <code>CONVERT</code> function?</p>