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.
INSTR(expression1 string, expression2 string) → int
- expression1: The input expression to search.
- expression2: The string to search for in the specified expression.
SELECT INSTR('Dremio', 'D') -- EXPR$0 -- 1
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.