INSTR

The INSTR function returns the position at which an argument starts within a specified string.

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

The schema is SYSIBM.

INSTR is identical to LOCATE_IN_STRING. For details, see LOCATE_IN_STRING.