troubleshooting Question

How to romove non-ASCII Characters such as "#" from an Address field in access query?

Avatar of SambaCor
SambaCor asked on
Microsoft AccessMicrosoft SQL Server
19 Comments1 Solution482 ViewsLast Modified:
I would like to remove (or replace) characters like "#" in the address field of my query. Some addresses look like this, 101 FRONT ST, #17 or 232 CANADA VALLEY RD APT #1 or 325 HESPERIAN BLVD #306...
The Address field already has these codes:
UCase(Left([Address],28))  & String(28-Len(Left(Nz([Address],""),28))," ") AS Ads

How can I modify the codes to include the removal (or replacement) of the character "#" for example?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 19 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros