I think you need to try this out ... the above comment (sorry dant12) is not correct:
It looks like the following will replace up to six spaces
REPLACE(@SomeText, ' ',' ')
And the following will sort the rest out :
REPLACE(REPLACE(@SomeText, ' ',' '),' ',' ')
try this one :
DECLARE @sample VARCHAR(1000)
SET @sample= 'ALKSDKLKJ LSJD ASD LSD S D DJD D D D D D D'
SELECT REPLACE(REPLACE(@sample,' ',' '),' ',' ')
C# Gnu
____________________________________________________