Home Forums SQL Server 2005 T-SQL (SS2K5) Ltrim rtrim no working with UPDATE RE: Ltrim rtrim no working with UPDATE

  • February 23, 2009 at 6:54 am

    #948546

    And this should correct the data....

    UPDATE #tablename

    SET colname = STUFF(colname,1,1,'')

    WHERE colname LIKE '%WDT'

    AND colname <> 'WDT'

    Far away is close at hand in the images of elsewhere.
    Anon.