INSTR - More Examples in Informatica

Example : Find the second occurrence of a character
INSTR( COMPANY, 'a', 1, 2 )

COMPANYRETURNComments
Informatica10-
Abnitio a0'a' is case sensitive search

Example : Find the occurrence of character 'a' from third character
INSTR(COMPANY,'a',3,1)

COMPANYRETURNComments
Informatica7-
Abnitio a9'a' is case sensitive search

Example : Find the first occurrence from end of the string
INSTR(COMPANY,'a',-1,1)

COMPANYRETURNComments
InformaticA5Search starts at the end of the string
Abnitio a1Search starts at the end of the string