INDEX( ) Search for string

The INDEX( ) function indicates the position of a search string within the overall string. The overall string can be searched from left to right or from right to left; the result value always relates to the beginning of the overall string.

Result type: INTEGER

INDEX( )

STRING = string_expression₁

,PATTERN = string_expression₂

,DIRECTION = *FORWARD / *REVERSE

,BEGIN-COLUMN = 1 / arithm_expression

,END-COLUMN = *LAST / arithm_expression