IS NULL Predicate

Tests for a null value.

Syntax

expression IS [NOT] NULL

Arguments

expression

specifies any valid SQL expression.

See <sql-expression>
FedSQL Expressions

Details

IS NULL is a predicate that tests for a null value. IS NULL is used in the WHERE, ON, and HAVING clauses. The IS NULL predicate resolves to true if the result of the SQL expression is null and resolves to false if it is not null.

Comparisons

The IS MISSING predicate tests for SAS missing values in SAS native data stores.

Example

select city
   from worldcitycoords
      where latitude is not null;
SAS creates the following table:
IS NULL Example Output Table
IS NULL Example Output Table

See Also

Predicates:
<search-condition> in the SELECT Statement
Last updated: February 23, 2017