AnsweredAssumed Answered

How to escape the hash tag / pound sign / number sign in a query

Question asked by jborgion on Apr 30, 2015
Latest reply on Apr 30, 2015 by jborgion

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.

Outcomes