# INSTR()

Syntax:

Then: a = INSTR(n,m,s)

Looks for field "m" in field "n" starting at position "s". The starting location in field "n"is returned as a number in field "a"; return value is "0" if field "m" is not found in field "n";

"a" is the return value

"n," "m," and "s" are expressions; "n" is the field you are searching
"m" is the field you are looking for
"s" (optional) is the character position in field "n" from which to start the search.

If the field is not found, INSTR returns a zero.

Version Ref: 4.1

Description:

INSTR looks for the contents of one field within a second field, beginning at a specified character position. INSTR returns the character position in the second field where the first field is found. INSTR can be used in an expression.