skip to main content
Expressions, conditions, and queries : Conditions
 

Conditions

A condition specifies a combination of one or more expressions and logical operators that evaluates to TRUE, FALSE, or unknown.
You can use a condition in the WHERE clause of these statements:
• DELETE
• SELECT
• UPDATE
You can use a condition in the HAVING clause of the SELECT statement.
The following table provides a description of the supported conditions.
 
Table 17: Conditions 
Condition
Description
Simple comparison condition1
A simple comparison condition specifies a comparison with expressions or subquery results.
=, !=, <>, <, >, <=, <=
Group comparison condition<superscript>1
A group comparison condition specifies a comparison with any or all members in a list or subquery.
[=, !=, <>, <, >, <=, <=] [ANY, ALL, SOME]
Membership condition
A membership condition tests for membership in a list or subquery.
[NOT] IN
Range condition
A range condition tests for inclusion in a range.
[NOT] BETWEEN
NULL condition
A NULL condition tests for nulls.
IS NULL, IS NOT NULL
EXISTS condition
An EXISTS condition tests for existence of rows in a subquery.
[NOT] EXISTS
LIKE condition
A LIKE condition specifies a test involving pattern matching.
[NOT] LIKE
Compound condition
A compound condition specifies a combination of other conditions.
CONDITION [AND/OR] CONDITION
1 Comparison conditions can be used to compare the values of LONGVARCHAR, WLONGVARCHAR, and LONGVARBINARY data. The values being compared must be the same data type. For example, you can compare a LONGVARCHAR value to another LONGVARCHAR value, but you cannot compare a LONGVARCHAR value to a LONGVARBINARY value.