Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL language elements

 

Search conditions

A search condition is the criteria specified for a WHERE clause, a HAVING clause, a CHECK clause, an ON phrase in a join, or an IF expression. A search condition is also called a predicate.

 Syntax
 Parameters
 Remarks
 Prerequisites
 Side effects
 See also

Subqueries in search conditions
ALL search condition
ANY and SOME search conditions
IS DISTINCT FROM and IS NOT DISTINCT FROM search conditions
BETWEEN search condition
LIKE, REGEXP, and SIMILAR TO search conditions
IN search condition
CONTAINS search condition
EXISTS search condition
IS NULL and IS NOT NULL search conditions
Truth value search conditions
Three-valued logic
Explicit selectivity estimates