LOCATE (Lakehouse v2)

Returns the position of the first occurrence of a substring in a string.

Analyze Syntax

func.locate(<substr>, <str>[, <pos>])

Analyze Examples

func.locate('or', 'hello world')

┌───┐
│ 8  │
└───┘

SQL Syntax

LOCATE(<substr>, <str>[, <pos>])

SQL Examples

SELECT LOCATE('or', 'hello world');

┌───┐
│ 8  │
└───┘