Example 2 - Analytics Database - Teradata Vantage

The following query returns the result 2, which indicates the position of the first occurrence of 'N' in the source string with the search starting from the beginning of the string.

SELECT INSTR('INSTR FUNCTION','N');