Find and Replace with an update query

D

debora085

I have a database with one column of mailing addresses. I am trying to change
"Apt" within mailing address to "#". Everything I have tried wipes out the
entire address and leaves just #.
 
A

Allen Browne

Use Replace().

This kind of thing:

UPDATE Table1
SET Address = Replace([Address], "Apt", "#")
WHERE Address Is Not Null;
 
Top