InterviewSolution
Saved Bookmarks
| 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. |
|