Example Syntax:
INSTR( source_string, substring [, start_position [, occurrance ] ] )
Example Usage:
INSTR('Welcome to PSOUG.org', 'o') would return 5 (Finds the first occurrence of 'o') INSTR('Welcome to PSOUG.org', 'o', 1, 1) would return 5. (Finds the first occurrence of 'o') INSTR('Welcome to PSOUG.org', 'o', 1, 2) would return 10. (Finds the second occurrence of 'o') INSTR('Welcome to PSOUG.org', 'o', 1, 3) would return 18. (Finds the third occurrence of 'o') INSTR('Welcome to PSOUG.org', 'o', -2, 2) would return 10. (Count back 2, then find the 2nd 'o')