Question: do spaces count as characters in sql?
Answer: The reason is because char(32) is the ASCII code value of a space character in T-SQL. LEN will only count leading spaces and spaces in between the string but will not count trailing spaces.