ORACLE : TRIM

SELECT ENAME, TRIM('A' FROM ENAME) "-a" , TRIM('J' FROM ENAME)"-J" FROM EMP
ORACLE;
 
POSTGRESQL
MYSQL