Use @VALONEOF to compare a field or string to a list of values. If the field is in the list, 1 is returned, otherwise 0 is returned.

Syntax

@VALONEOF (expression, value [, value] [, ...])

Example

If STATE is CA or NY, this expression returns "COAST".

@IF (@VALONEOF (STATE, "CA", "NY"), "COAST", "MIDDLE")