Skip to contents

DuckDB function instr

Source: R/duckdb-funs.R
instr.Rd

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

Usage

instr(string = VARCHAR, search_string = VARCHAR)

Arguments

string

VARCHAR

search_string

VARCHAR

Value

BIGINT

SQL examples

instr('test test', 'es')