Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden REPLACE Multiple Spaces with One RE: REPLACE Multiple Spaces with One

  • November 16, 2009 at 3:13 am

    #1079578

    Richard Briggs (11/16/2009)

    Hi

    Does this simple replace not work then?

    REPLACE(@SomeText, ' ',' ')

    which is actually :

    REPLACE(@SomeText, '[space][space]','[space]')

    i.e. replace two spaces with one..

    This seams to work fine for me, but I could well be missing something?

    sure, it works. if you only have 2 spaces it will work. the problem on the article however is for when u have a random amount of spaces.

    with your example you would have to manually add a REPLACE for each extra space

    --
    Thiago Dantas
    @DantHimself