DB2 Version 9.7 for Linux, UNIX, and Windows

INSTR scalar function

Read syntax diagramSkip visual syntax diagram
>>-INSTR--(--source-string--,--search-string--+---------------------------+--+--------------------+--)-><
                                              '-,--start--+-------------+-'  '-,--+-CODEUNITS16-+-'      
                                                          '-,--instance-'         +-CODEUNITS32-+        
                                                                                  '-OCTETS------'        

The schema is SYSIBM

The INSTR function returns the starting position of a string (called the search-string) within another string (called the source-string).

The INSTR scalar function is a synonym for the LOCATE_IN_STRING scalar function.