Skip to main content
Version: 24.3.x

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.