Previous Topic

Next Topic

SQL Extended Comparison Operators

Use extended comparison operators to perform comparisons on data in SELECT queries. The following outlines the extended comparison operators supported by the SQL engine.

Operator

Description

[NOT] BETWEEN

Compares a value to a range formed by two values.

[NOT] IN

Determines if a value exists in a list of values.

[NOT] LIKE

Compares, in part or in whole, one value with another.

IS [NOT] NULL

Compares a value with an empty, or NULL, value.

[NOT] SIMILAR TO

Compares a value with a regular expression.

In This Section

SQL BETWEEN Extended Comparison Operator

SQL IN Extended Comparison Operator

SQL LIKE Extended Comparison Operator

SQL IS NULL Extended Comparison Operator

SQL SIMILAR TO Extended Comparison Operator

See Also

SQL Operators

Book Contents

Book Index