• 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,' ',' '),' ',' ')