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