INSTR

Returns the starting position of the first character in one string (string2) within another string (string1). If string2 is not found within string1, then this function returns zero (0).

Return Value

Integer

Syntax

INSTR( string1, string2 )

where:

  • string1 is the string you are evaluating.
  • string2 is the (sub)string you are looking for within string1, for which the starting position is to be returned.