INSTR
Learn how to use the INSTR string function in PlaidCloud Lakehouse. Returns the position of the first occurrence of a substring in a string.
Returns the position of the first occurrence of a substring in a string.
Analyze Syntax
func.instr(<str>, <substr>)
Analyze Examples
func.instr('hello world', 'world')
┌───┐
│ 7 │
└───┘
SQL Syntax
INSTR(<str>, <substr>)
SQL Examples
SELECT INSTR('hello world', 'world');
┌───┐
│ 7 │
└───┘