Remove all text from an MS access field
Posted on 2011-09-15
I have a field in MS Access 2007 that I want to change to only digits. I want to remove all text from the string, text can appear anywhere in the string, or not at all.
Once I have just the numbers, I want to remove any leading zeros. I think that's simple enough with trim, I'm happy to figure that out on my own. I really just need help removing the text.