The text expression for which the function searches.
The text expression for which the function searches. It is usually a text literal and can contain up to 512 bytes. The function interprets a period as a wildcard character that matches any character
A positive integer that indicates the character of source_char at which the function begins the search. The default value of position is
1, which means that the function begins searching at the first character of source_char.
A positive integer that indicates which occurrence of pattern the function should search for. The default value of occurrence is
1, which means that the function searches for the first occurrence of pattern.
A text expression that lets you change the default matching behavior of the function. You can specify one or more of the values shown in the following table.
||Treat the source string as multiple lines. The function interprets
||A newline character is among the characters matched by a period (the wildcard character). By default, it is not.|
||Ignores whitespace characters.|
The following statement
REGEXP_SUBSTR('7 W 96th St, New York, New York', 'new york', 10, 2, 'i')
starts searching at the tenth character and matches the second instance of New York in a case-insensitive match.