Explain What Is Difference Between SUBSTR And INSTR

Explain What Is Difference Between SUBSTR And INSTR


  • 7 Mar, 2012

    SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDEINSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.