We can trim extra spaces from right hand side from a string using RTRIM function:-
SELECT RTRIM('This Is Me. ');
Output is:- This is me. (Without trailing spaces)
SELECT RTRIM('This Is Me. ');
Output is:- This is me. (Without trailing spaces)