Specifications

Chapter 15. Function Reference
364
:
Syntax:
INSTR([startposition,]targetstring,searchstring)
Parameter:
startposition
A numeric expression which returns a value from 1 to 32767.
targetstring and searchstring
A string expression.
Description:
INSTR searches a target string specified by targetstring to check whether a
search string specified by searchstring is present in it, and then returns the
first character position of the search string first found.
•
startposition is the character position where the search is to begin in
targetstring. If you omit startposition option, the search begins at
the first character of targetstring.
•
targetstring is the string being searched.
•
searchstring is the string you are looking for.
IN STRing String function
INSTR
Searches a specified target string for a specified search string, and then returns the position
where the search string is found.
NOTE
Do not mistake the description order of targetstring and search-
string.