I need your help. I have been tasked with a project of updating Address_1 and Address_2 in the Name_Address table. I found some script that will work but ran into a snag and need some help.
On a test table, I ran the following script to correct an address of 105 Drake Dr
UPDATE tempjohncross
SET Address_1=(
REPLACE (Address_1,
'Dr',
'Drive'));
The script fixed the record as 105 Driveake Drive