SQL_RTRIM1
Oracle: PostgreSQL/ MySQL
SELECT ENAME, rtrim(ENAME,'N')"-N" , rtrim(ename,'S')"-S" from emp
Oracle:
POSTGRESQL
MySQL