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 pretty much a beginner when it comes to SQL Server administration, so I'm kinda in the dark here.<BR><BR>BTW, both servers use SQL Server 2000.