SQL Server 2005 Frustration

Yes, MS SQL server takes character cases casually -- 'Everything' = 'eVERYthING'
Yes, MS SQL server are not friendly to empty string -- LEN('') = 1
But this is ridiculous: The following statements returns true.

• LEN('TEST      ') = 4
• 'TEST      ' = 'Test'