Text & patterns
Scalar
instr()
Returns location of first occurrence of search_string in string, counting from 1. Returns 0 if no match found.
Reference: DuckDB 2.0.0
Arguments & returns
instr(string, search_string)
Scalar
| Overload link | string | search_string |
Returns |
|---|---|---|---|
| #01 | VARCHAR | VARCHAR |
BIGINT |
Example
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.