How to romove non-ASCII Characters such as "#" from an Address field in access query?
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?
Microsoft AccessMicrosoft SQL Server
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.