Indeed
I also realised why it can't work in a 'loop till it's finished' kind of way - because if you did REPLACE(expression, ' ', ' ') then it would never terminate...
M
Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone