in_set

Format:

in_set( int_expr, text_expr)

Result:

0 or 1.

Description:

The functions returns 1, if a number is a member of the specified set.

e.g.:

SPECTRA> * = in_set(1, “1 2 3”)
1
SPECTRA> * = in_set(4, “1 2 3”)
0