All of these functions return true or false, so they're great as part of Boolean expressions in either case functions or aggregate functions.
function |
definition |
even( k ) |
Returns true if the
argument is an even integer. |
odd( k ) |
Returns true if the
argument is an odd integer. |
exists( a ) |
Returns true for cases where a has a value. In this case, if a is absent or missing, it returns false. |
includes(s, sub) |
Returns true if the
second string is a substring of the first. |
inRange(a, min, max) |
Returns true if the
first argument is between the other two. The
range includes the lower bound but excludes the upper. |
isNumber( x) |
Returns true if the
argument is a number. |