The INSTRB function returns the starting position, in bytes, of a string within another string.

The schema is SYSIBM.

source-string

An expression that specifies the string in which the search is to take place.

search-string

An expression that specifies the string that is the object of the search.

start

An expression that specifies the position within the source string at which the search for a match is to start.

instance

An expression that specifies which instance of the search string to search for within the source string.

The INSTRB scalar function invoked with character or graphic strings as the first two arguments is equivalent to invoking the LOCATE_IN_STRING function with OCTETS specified.
The INSTRB scalar function invoked with binary strings as the first two arguments is equivalent to invoking the LOCATE_IN_STRING function without a string units argument.

Related reference

• LOCATE_IN_STRING scalar function