I am trying to remove extra space in a string but is not working.
Here is the string.
"31 Enida 32-57^^^Manchester CITY Manchester"
Here is query.
USE TEST UPDATE MyTable SET Address = replace(Address, '31 Enida 32-57 Manchester CITY Manchester', '31 Enida 32-57 Manchester CITY Manchester')
Still there are three blank spaces
Between 32-57 and Manchester.
I think there are non printable character in the string.
Please help me.
Thanks in advance