Predicates are truth-tests. If the predicate test is true, it returns a value. Each predicate is evaluated per row so that when the predicate is part of an entire table SELECT statement, the statement can return multiple results.
Predicates consist of a set of parameters and arguments. For example, in the following example WHERE clause:
WHERE name = 'Smith';
name = 'Smith'
is the predicate'Smith'
is an expression
Predicates can be achieved using:
- BETWEEN Operator
- EXISTS Operator
- IN Operator
- LIKE Operator
- Search condition statements
Lyftron provides the following predicates.
IS [NOT] NULL
Determines whether a specified expression is NULL.
Syntax
expression IS [ NOT ] NULL
Arguments
expression
Is any valid expression.
NOT
Specifies that the Boolean result has to be negated. The predicate reverses its return values, returning TRUE if the value is not NULL, and FALSE if the value is NULL.
Result Types
Boolean