I've got a ton of address records in a personal geodatabase that I need to geocode. (it's in a pgdb because much of it is trash and scrubbing strings is easier for me in access....)
Several thousand records are in the form of:
1234 S Main St #1
I want to select those that have the # sign in the address field, but I can't seem to figure out how to escape it for a literal interpretation in my selection query. Once I do I can pop() the offending apartment number off and get back to geocoding.