It is really strange that I never ran into this before, but today while developing a piece of code – I looked at the documentation of T- SQL LEN() Function carefully:
It says: “Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.”
Hhmmm.. I can say that I have overlooked this thing till today. And due to this reason, the below query returns the same result. Check this out:
SELECT LEN(‘ABC‘) AS ‘WithOut_Space‘, LEN(‘ABC ‘) AS ‘With_Space‘
I never checked or noticed that LEN does not return full length, trailing spaces. Glad I noticed it today.