Column value predicate

Syntax

column-name comparison-op constant-expression

Parameters

column-name	A single column of one the tables specified in the FROM clause.
comparison-op	A Comparison operators.
constant-expression	A constant value of the same data type as the column-name.

Notes

To check a column value for NULL, use the NULL predicate.

Examples

table.column1 = 2
table.column2 = 'Seafood'
table.column3 IS NULL