position()

Returns location of first occurrence of search_string in string, counting from 1. Returns 0 if no match found.

Reference: DuckDB 2.0.0

Alias of instr()

Arguments & returns

position(string, search_string)

Scalar
Overload link stringsearch_string Returns
#01 VARCHARVARCHAR BIGINT

Example

position example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.