INSTR_UDF (STRING, STRING)

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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

Definition

Searches the source_string argument for occurrences of searh_string.

PUBLIC.INSTR_UDF(SOURCE_STRING STRING, SEARCH_STRING STRING) 

Parameters

SOURCE_STRING STRING

The string where the search will be conducted.

SEARCH_STRING STRING

The string that the function searches for.

Returns

The position in the source string where the occurrence is found (starting at 1).

Usage example

Input:

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

Output:

2