Skip to main content

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