Position

String Function

Description

Location of specified substring

Click here to navigate to the Postgre docs page for this syntax.

The function Position() is supported on snowflake

Grammar Syntax

position(substring in string)

Sample Source Patterns

Postgre

Code

SELECT
    POSITION('os' in 'position')
FROM
   Table1;

Result

2

Snowflake

Code

SELECT
    POSITION('os' in 'position')
FROM
   Table1;

Result

2