remove column trail space in sql

SQL Server RTRIM() function is used to trim trailing characters from a character string.