SQL_RTRIM1
Oracle: PostgreSQL/ MySQL

SELECT ENAME, rtrim(ENAME,'N')"-N" , rtrim(ename,'S')"-S" from emp

Oracle:

POSTGRESQL

MySQL