Instr function seems to be vague

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • movenk
    New Member
    • Dec 2013
    • 1

    Instr function seems to be vague

    I issued the following commands and get answers which are not consistent ,Can anyone explain to me how the positions are generated?Thank s
    SQL> select instr('Eagritt' , 'e') from dual;

    INSTR('EAGRITT' ,'E')
    --------------------
    0

    SQL> select instr('Eagritt' , 'a') from dual;

    INSTR('EAGRITT' ,'A')
    --------------------
    2
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Are you using lower case or upper case? It's case sensitive.

    Comment

    Working...