Get the sub string position by using instr
SQL> SQL> select instr( 'Samantha', 'man' ) position from dual; POSITION ---------- 3 1 row selected. SQL> SQL> --