INDEX returns a FIXED value indicating the starting position within x of a substring identical to y. You can also specify the location within x where processing begins.
|
x should have CHARACTER type, and if not, it will be converted thereto.
y should have CHARACTER type, and if not, it will be converted thereto.
n should have FIXED type, and if not, it will be converted thereto.
If y does not occur in x, or if either x or y have zero length, the value zero is returned.
n must be greater than 0 and no greater than 1 + LENGTH(x).
If n = LENGTH(x) + 1, the result is zero.