INSTR_UDF (STRING, STRING, DOUBLE, DOUBLE)

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

Definition

Searches the source_string argument for occurrences of searh_string.

PUBLIC.INSTR_UDF(SOURCE_STRING STRING, SEARCH_STRING STRING, POSITION DOUBLE, OCCURRENCE DOUBLE)

Parameters

SOURCE_STRING STRING

The string where the search will be conducted.

SEARCH_STRING STRING

The string that the function searches for.

POSITION DOUBLE

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

OCCURRENCE DOUBLE

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('CHOOSE A CHOCOLATE CHIP COOKIE','CH',2,2);

Output:

20