1.

Difference Between Substr And Instr ?

Answer»

INSTR (STRING1,String2(n,(m)),INSTR returns the position of the MTH occurrence of the string 2 instring1. The SEARCH begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of SIZE m in string1, starting from nth position of string1.

INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.



Discussion

No Comment Found