This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

STRPOS

Returns the position (in bytes) of the substring found in the string, starting from 1. The returned value is for the first matching value, and not for any subsequent valid matches. In case the substring does not exist, functions will return 0.

Syntax

STRPOS(<string>, <substring>)

Example

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

Returns: 1

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

Returns: 7

SELECT
	STRPOS('hello world','work') AS res;

Returns: 0