SQL> SQL> -- Add anchors or "wildcard" match characters as need be. SQL> SQL> SELECT REGEXP_INSTR('Hello','^.',2) FROM dual; REGEXP_INSTR('HELLO','^.',2) ---------------------------- 0 SQL>