Removing all letters or all numbers from string

[Hayley_sql]

I would like to create an address matchkey, so remove all letters from a string. Then remove all numbers and vowels in the string, then extract first 4 characters of remaining letters. Put selected numbers and letters back together in a new field. Have code to something similar in sql, but currently am limited to working in access.



Any suggestions?

[RuralGuy]

How about an example of some sample data?

[dcrake]

Are you trying to create a soundex search? If so there is an example in this http://www.access-programmers.co.uk/...d.php?t=173710 link.

David