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

[JoeBorgione]

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.

[JoeBorgione · Accepted solution]

Found it:  [fieldname] like '*[#]*'