INSTR scalar function The INSTR function returns the starting position of a string (the search string) within another string (the source string). The INSTR scalar function is a synonym for the LOCATE_IN_STRING scalar function. INSTR(source-string, search-string ,start,instance ,CODEUNITS16CODEUNITS32OCTETS ) The schema is SYSIBM