Skip to main content
Version: current [24.3.x]

STRPOS

Categories: String

STRPOS

Searches for the first occurence 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('dremio cloud service', 'cloud')
-- 8
STRPOS example
SELECT STRPOS(1001111, 00)
-- 2
STRPOS example
SELECT STRPOS('dremio 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.