POS

Syntax:

(NCDTY value_1, NCDTY value_2)

Return Value:

N position

Description:

POS determines the position of one field in another larger field. POS works for character fields and multi occurs fields of any type. If there is no match the value given is zero

Example:

POS("EL","HELLO") = 2
POS(7, 12|3|7|37) = 3