Is not SQL 2005 not 100% percent compitable with .NET ?

Question

Books say that trailing spaces are ignored when comparing two strings in SQL. This is true when the comparision is made from SQL editor. But from C# code this is not true and the comparion yeilded false just becaause of one trailing whitespace characteer .