This is a
select empno,ENAME, DEPTNO FROM emp WHERE INSTR(ename,'BLAKE') > 0
PostgreSQL;
SELECT ENAME, position('A' in ename)"#A" , position('E' in ename)"#E" from emp