SQL_REPLACE1.htm
REPLACE:

SELECT ENAME, REPLACE(ENAME,'A','##') "-A" , REPLACE(ENAME, 'E', '**')"-E" FROM EMP

ORACLE:

POSTGRESQL

MYQL