how to remove trailing space in sql server

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