1.

Difference Between Substr And Instr?

Answer»

INSTR (STRING1, String2 (n, (m)),
INSTR returns the position of the m-th occurrence of the STRING 2 in string1. The SEARCH begins from nth position of string1.

SUBSTR (String1 n, m)
SUBSTR returns a character string of size m in string1, STARTING from n-th position of string1.

INSTR (String1, String2 (n, (m)),
INSTR returns the position of the m-th occurrence of the string 2 in string1. The search begins from nth position of string1.

SUBSTR (String1 n, m)
SUBSTR returns a character string of size m in string1, starting from n-th position of string1.


Discussion

No Comment Found

Related InterviewSolutions