STRPOS (Lakehouse v2)

Returns the position of the first occurrence of a substring. Alias for LOCATE.

Analyze Syntax

func.strpos(<str>, <substr>)

Analyze Examples

func.strpos('hello world', 'world')

┌───┐
│ 7  │
└───┘

SQL Syntax

STRPOS(<str>, <substr>)

SQL Examples

SELECT STRPOS('hello world', 'world');

┌───┐
│ 7  │
└───┘