This string is in a table column called complete_address: “2921 N 73RD”.
I need to get rid of the double space between “N” and “73RD”.
Why doesn’t this code work?:
UPDATE master SET complete_address = REPLACE(complete_address,' ',' ')
Figured it out. Thanks for the time you spent reading my topic.