topic Re: How to escape the hash tag / pound sign / number sign in a query in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-escape-the-hash-tag-pound-sign-number-sign/m-p/744220#M41912 <HTML><HEAD></HEAD><BODY><P>Found it:&nbsp; [fieldname] like '*[#]*'</P></BODY></HTML> Thu, 30 Apr 2015 19:17:32 GMT JoeBorgione 2015-04-30T19:17:32Z How to escape the hash tag / pound sign / number sign in a query https://community.esri.com/t5/data-management-questions/how-to-escape-the-hash-tag-pound-sign-number-sign/m-p/744219#M41911 <HTML><HEAD></HEAD><BODY><P>I've got a ton of address records in a personal geodatabase that I need to geocode.&nbsp; (it's in a pgdb because much of it is trash and scrubbing strings is easier for me in access....)</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Several thousand records&nbsp; are in the form of:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>1234 S Main St #1</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>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.&nbsp; Once I do I can pop() the offending apartment number off and get back to geocoding.</P></BODY></HTML> Thu, 30 Apr 2015 18:50:46 GMT https://community.esri.com/t5/data-management-questions/how-to-escape-the-hash-tag-pound-sign-number-sign/m-p/744219#M41911 JoeBorgione 2015-04-30T18:50:46Z Re: How to escape the hash tag / pound sign / number sign in a query https://community.esri.com/t5/data-management-questions/how-to-escape-the-hash-tag-pound-sign-number-sign/m-p/744220#M41912 <HTML><HEAD></HEAD><BODY><P>Found it:&nbsp; [fieldname] like '*[#]*'</P></BODY></HTML> Thu, 30 Apr 2015 19:17:32 GMT https://community.esri.com/t5/data-management-questions/how-to-escape-the-hash-tag-pound-sign-number-sign/m-p/744220#M41912 JoeBorgione 2015-04-30T19:17:32Z