Determines whether a lookup key exists in a lookup table. Specify the LOOKUP function as the expression for the term whose value contains the lookup key that you want to search for.
Restrictions: | You can specify the LOOKUP function in condition expressions only. |
If an expression contains the LOOKUP function, then the expression cannot contain anything else. | |
Returned data type: | Boolean |
specifies the name of the lookup table that you want to search.
CA
, then the following expression
evaluates to True.