INDEX Locates a character or a substring within a string and returns its location within the string. Syntax integer := INDEX (string1, string2) Parameters string1 The string within which you want to find a character or a substring. Put the string in quotes. string2 The character or substring whose leftmost character location you want to find within string1. Put the string in quotes. Example loc := INDEX ("1234567", "67") Stores an integer value of 6 in the variable LOC, since the substring 67 is found starting at character position 6 within the string 1234567.