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

INSTR

Categories: String

INSTR

Returns the position of the first occurrence of a string when it is contained in another string. If no such occurrence is found, a zero is returned. The comparison is case-sensitive.

Syntax

INSTR(expression1 string, expression2 string) → int

  • expression1: The input expression to search.
  • expression2: The string to search for in the specified expression.

Examples

INSTR example
SELECT INSTR('Dremio', 'D')
-- 1
INSTR example
SELECT INSTR('Dremio', 'd')
-- 0