When a table column is of fixed string length (like "char" and "nchar" in SQL Server) the database engine will return the string value padded with spaces.


These trailing spaces are removed (by the runtime) while copying string values into the resultset.