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:50 am

    #948544

    I would do the following to find the offending values

    SELECT colname,CAST(colname as varbinary(5))

    FROM tablename

    WHERE colname LIKE '%WDT'

    AND colname <> 'WDT'

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