Skip to contents

DuckDB function position

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

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

Usage

position(string = VARCHAR, search_string = VARCHAR)

Arguments

string

VARCHAR

search_string

VARCHAR

Value

BIGINT

SQL examples

position('b' IN 'abc')