I'm running an insert T-SQL statement to inter one record from one table to another. There is an nvarchar(100) field in the insert. Even if a wrap the nvarchar field in RTRIM or SUBSTRING, the insert result is that the target table field includes the padding of spaces beyond the value of the field. For example, if the value of the source field is "Answer", the value in the target field after the insert is "Answer ", i.e., the value + spaces. Any thoughts?