Comparison Templates

Comparison functions evaluate to Boolean by comparing values to the left and right of the operator.

Function	Template format	Return type
is among	<field> is among <value>, <value>, [add value] *List of values of same data type as left side of comparison	Boolean
is not among	<field> is not among <value>, <value>, [add value] *List of values of same data type as left side of comparison	Boolean
is at least	<numeric> is at least <numeric expression>	Boolean
is at most	<numeric> is at most <numeric expression>	Boolean
is between	<date or numeric> is between <date or numeric expression> and <date or numeric expression>	Boolean
is not betwee n	<date or numeric> is not between <date or numeric expression> and <date numeric expression>	Boolean
is equal to	<Field> is equal to <value> *value of same data type as left side of comparison	Boolean
is Not Null	<field> is not NULL	Boolean
is NULL	<field> is NULL	Boolean
is not empty	<field> is not empty	Boolean
is a number	<value> is a numbe r	Boolean
is greater than	<numeric> is greater than <numeric expression>	Boolean
is greater than or equal to	<numeric> is greater thanor equal to <numericexpression>	Boolean
is less than	<numeric> is less than<numeric expression>	Boolean
is less than or equal to	<numeric> is less than orequal to <numericexpression>	Boolean
is after	<date> is after <dateexpression>	Boolean
is on or after	<date> is on or after <dateexpression>	Boolean
is not after	<date> is not after <dateexpression>	Boolean
is before	<date> is before <dateexpression>	Boolean
is not before	<date> is not before <dateexpression>	Boolean
is on or before	<date> is on or before<date expression>	Boolean
is null or empty	<field> is null or empty	Boolean
is not null or empty	<field> is not null or empty	Boolean
is TRUE	<Boolean> is TRUE	Boolean
is FALSE	< Boolean> is FALSE	Boolean