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)
Rick Farris
nimbussoftware.com