TRAILING: trim from the end of a string
SQL> SQL> -- TRIM 'TRAILING' SQL> SQL> SELECT TRIM(TRAILING 'S' FROM 'STEVENS' ) AS TRIM FROM Dual; TRIM ------ STEVEN SQL>