SQL Predicates

SQL language predicates are used in a select statement where clause to limit result set rows. The eXtremeSQL predicate operators are the following:

between	Values between the specified bounds
like, ilike	String values matching a specified pattern
in	Values contained in a specified set
exists	Value is present in a result set
exact_match	exact match (Patricia trie)
prefix_match	longest prefix match (Patricia trie)