Home Forums Programming General string Comparison. RE: string Comparison.

  • March 14, 2011 at 3:58 am

    #1298242

    Henrico Bekker (3/14/2011)

    try the following:

    select LEN(string2),len(RTRIM(LTRIM(string2))) from yourtablename

    and compare the length it records.

    However note (from Books Online)

    LEN (Transact-SQL)

    Returns the number of characters of the specified string expression, excluding trailing blanks.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass