I have a load of records that have double-spaces in the address. I want to create an sql query to take the spaces out and replace them with a comma and a space. I cant seem to write anything that will recognise a double-space. Does anyone know how to? Have tried using patindex and charindex but cant get it to work.
I hope someone can help