• Yes.  LEN counts leading blanks (white space), but omits the trailing ones. 

    In case there are persons interested...

    If you were expecting a count of 8, you needed to use "DATALENGTH" instead of "LEN".  Here's the syntax:

    DECLARE @myString varchar(100)

    SET @myString = '  TEST  '

    SELECT DATALENGTH(@myString)


    Kindest Regards,

    Rick Farris
    nimbussoftware.com