INSTR_UDF (STRING, STRING, INT)

This is the user-defined function (UDF) overloaded with three parameters.

Definition

Searches the source_string argument for occurrences of searh_string.

PUBLIC.INSTR_UDF(SOURCE_STRING STRING, SEARCH_STRING STRING, POSITION INT)

Parameters

SOURCE_STRING STRING

The string where the search will be conducted.

SEARCH_STRING STRING

The string that the function searches for.

POSITION INT

The character index where the search will start (starting at 1).

Returns

The position in the source string where the occurrence is found.

Usage example

Input:

SELECT INSTR_UDF('FUNCTION','N', 3);

Output:

8