how to remove trailing space from string in sql

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