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')
-- EXPR$0
-- 1

INSTR example

SELECT INSTR('Dremio', 'd')
-- EXPR$0
-- 0

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.