Source
POSITION
Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1 - based) of the first argument in the second argument.
ARRAY_POSITION Function: Changes to Finding the Position of a NULL Value
When you call the ARRAY_POSITION function and pass in a value as the first argument, the function returns the position of the first ARRAY element with that value.
ARRAY_POSITION
Returns the index of the first occurrence of an element in an array.
Sep 12, 2025: Support for position row-level deletes when writing to externally managed Apache Iceberg™ tables or catalog-linked databases on Amazon S3 or Google Cloud (Preview)
Snowflake now supports position row - level deletes when writing to externally managed Apache Iceberg™ or Iceberg tables in catalog - linked databases when the tables are stored on Amazon S3 or Google Cloud. These deletes are supported when…
Sep 19, 2025: Support for position row-level deletes when writing to externally managed Apache Iceberg™ tables or catalog-linked databases on Azure (Preview)
Snowflake now supports position row - level deletes for Azure when writing to externally managed tables. These deletes are supported when Snowflake performs update, delete, and merge operations on the table files. This feature is a…
Why do I see gaps in the ORDINAL_POSITION column in the INFORMATION_SCHEMA.COLUMNS view after cloning a table?
The above behavior may be observed when a column or columns are dropped in the source table. Because a cloned table references the original table's micro partitions, original micro partitions may have information or other tables could be…
REGEXP_INSTR
Returns the position of the specified occurrence of the regular expression pattern in the string subject. See also String functions (regular expressions).
BITMAP_BIT_POSITION
Given a numeric value, returns the relative position for the bit that represents that value in a bitmap.
CHARINDEX
Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1 - based) of the first argument in the second argument.
SELECT
SELECT can be used as either a statement or as a clause within other statements: As a statement, the SELECT statement is the most commonly executed SQL statement; it queries the database and retrieves a set of rows. As a clause, SELECT…