Find and Replace with an update query

[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 #.

 

[Allen Browne]

Use Replace().

This kind of thing:

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

 

[boblarson]

Should be:

YourNewFieldName:Replace([YourOriginalFieldName],"Apt","#")

--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________