position()

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

Alias of instr()

Arguments & returns

position(string, search_string)

Scalar
Overload link stringsearch_string Returns
#01 VARCHARVARCHAR BIGINT

Example

position example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.