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?