Question

Explain INSTR function with an example​

Answer 1

Answer:

The INSTR() function returns the position of the first occurrence of a string in another string. This function performs a case-insensitive search. The INSTR functions search string for substring . The function returns an integer indicating the position of the character in string that is the first character of this occurrence. INSTR calculates strings using characters as defined by the input character set.

Explanation:

Answer 2

Answer:

The INSTR() function returns the position of the first occurrence of a string in another string. This function performs a case-insensitive search.