Start of change

INSTR

The INSTR function returns the starting position of a string (called the search-string) within another string (called the source-string). If the search-string is not found and neither argument is null, the result is zero. If the search-string is found, the result is a number from 1 to the actual length of the source-string. If the optional start is specified, it indicates the character position in the source-string at which the search is to begin.

Read syntax diagramSkip visual syntax diagramINSTR(source-string ,search-string ,start,instance )

The INSTR function is identical to the LOCATE_IN_STRING function. For more information, see LOCATE_IN_STRING.

End of change