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

2205
1
Jump to solution
04-30-2015 11:50 AM
Highlighted
MVP Esteemed Contributor

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.

Tags (1)
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Esteemed Contributor

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

View solution in original post

Reply
0 Kudos
1 Reply
Highlighted
MVP Esteemed Contributor

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

View solution in original post

Reply
0 Kudos