Home Forums SQL Server 2012 SQL Server 2012 - T-SQL LTRIM/RTRIM RE: LTRIM/RTRIM

  • April 23, 2015 at 4:53 am

    #1792972

    serg-52 (4/23/2015)

    Check UNICODE() of the problem symbol and collation. Under some collations ASCII=32 doesn't mean UNICODE =32 which is required for trim() functions.

    Great catch!

    -- Gianluca Sartori