Question

Which of the following functions is used to find the position of the particular substring within a string?

Answer 1

Explanation:

Which of the following functions is used to find the position of the particular substring within a string?

Answer 2

The answer to the given question is as follow:

• The INSTR function finds the first occurrence of a substring in a string and returns its location. The INSTR function returns zero if the substring is not found in the str (0).
• Based on a count of substring occurrences, the INSTR function searches a character string for a specified substring and returns the character position in that string when an occurrence of that substring terminates.