Replacing White Space in String 1

[Robinstwitcher]

Am trying to clean up data. I am using LTRIM, RTRIM but also need to remove unnecessary spaces within the string.

e.g.

This is my string

should be

This is my string

Any solutions?

 

[earthandfire]

Use the Replace function to replace ' ' with ''.



Hope this helps.

 

[Robinstwitcher]

Apologies for my absolute stupidity - had used a cursor with the replace. However, forgot to write the cursor back to the table - hence no update. Thanks for your prompt response.