All I want to do is replace duplicate spaces with one space and I don't seem to be able to get it to work. The spaces occur in the middle of the text so trim won't work and this is someone else's ...

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...