Home > DeveloperSection > Interviews > What is difference between SUBSTR and INSTR?

Posted on    January-31-2014 11:55 PM

 1 Answer(s)
  1270  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    January-31-2014 1:00 AM

 INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence.SUBSTR function return a portion of string, beginning at character position, substring_length characters long.SUBSTR calculates lengths using characters as defined by the input character set.

Don't want to miss updates? Please click the below button!

Follow MindStick