Predicates in SQL
Predicates are keywords that specify a relationship between two expressions.
SQL supports the following types of predicates:
• Comparison
• Pattern matching:
– LIKE
– BEGINNING, ENDING, CONTAINING
– SIMILAR TO
• BETWEEN
• IN
• Any-or-All
• EXISTS
• IS NULL
• IS INTEGER
• IS DECIMAL
• IS FLOAT
• IS TRUE, IS FALSE, IS UNKNOWN
Note: The long data types (long varchar, long byte, and long nvarchar) cannot be used with predicates that need to inspect the content of data, such as to determine equality. The pattern-matching predicates can be used with long varchar and long nvarchar.