STRPOS

Searches for the first occurrence of the substring in the given expression and returns the position of where the substring begins. Searching binary values is also supported.

Syntax

STRPOS(expression varchar, substring varchar) → int32

• expression: The expression to search.

• substring: The substring to search the expression for.

Examples

STRPOS example

SELECT STRPOS('spice cloud service', 'cloud')
-- 8

STRPOS example

SELECT STRPOS(1001111, 00)
-- 2

STRPOS example

SELECT STRPOS('spice cloud service', 'sql')
-- 0

Usage Notes

If the substring is not found, the function returns 0. The data type of both parameters must match; specifically, they should both be either strings or binary values.