title: How to retrieve only the alphanumeric from a string in SQL/Access?
body: <p>I have a column that have to clean from numbers and spaces that looks like:</p>
  
  <pre><code>    XX = 
  TERR
  6 ST
  3 ST
  4 ST
   AVE
  2 PL
  2 PL
  2 PL
  2 PL
  4 CT
  2 PL
  4 ST
  3 ST
  3 ST
  </code></pre>
  
  <p>I mean, I need the opposite function to Val(), but can't find it. Any ideas?
  Thanks!</p>