Home Forums SQL Server 2005 T-SQL (SS2K5) Replace not replacing all instances of text in a string RE: Replace not replacing all instances of text in a string

  • November 21, 2014 at 6:48 am

    #1760104

    richardmgreen1 (11/21/2014)

    Thanks for that.

    I'm currently looking at several repalce statements to remove the text in pieces rather than all at once.

    I'll let you know how that goes.

    A nested REPLACE should do it all in one go. This sort of thing:

    replace(replace(replace(expr, tab, space), double space, single space),'Verdana 4d','')

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.