Reference Guide > TDV Support for SQL Functions > Character Functions > REGEXP_INSTR
 
REGEXP_INSTR
The function evaluates strings using characters as defined by the input character set. It returns an integer indicating the beginning or ending position of the matched substring, depending on the value of the return_option argument.
Syntax
REGEXP_INSTR(string, pattern to search, position to begin search, nth occurrence to search for, return_option, case sensitivity parameter)