Logical Functions

📄️ Between

Determines whether a given number falls within a specified range; returns True if the given number does exist in the specified range.

Determines whether a given value exists in a given vector; returns True if the given number does exist in the specified vector.

Returns true if the value is of date type.

Returns True if number is even, or False if number is odd.

Returns true if the value is of float type or false if not.

Returns true if the value is of integer type or false if not.

Returns True if column contains null value or False if not.

Returns True if column contains empty value (does not include nulls) or False if not.

Returns True if column contains empty value including nulls or False if not.

Returns True if number is odd, or False if number is even.

Works similar to a switch case statement.

Checks if the given input matches the search pattern (similar to SQL LIKE predicate).