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?:

Code:
UPDATE master SET complete_address = REPLACE(complete_address,'  ',' ')