SQL_REPLACE1.htm
REPLACE:
SELECT ENAME, REPLACE(ENAME,'A','##') "-A" , REPLACE(ENAME, 'E', '**')"-E" FROM EMP
ORACLE:
POSTGRESQL
MYQL