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 ...

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 ...