SQL> --RTRIM function removes trailing characters. SQL> SQL> SELECT RTRIM('S' , 'STEVENS') AS TRIM FROM Dual; T - SQL>