IS FALSE Predicate

Tests for a false value.

Syntax

(expression) IS [NOT] FALSE

Arguments

expression

specifies any valid SQL expression.

See <sql-expression>
FedSQL Expressions

Details

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

Comparisons

The IS TRUE predicate tests for true values.

Example

select city 
   from worldcitycoords
      where (latitude = 40) is false;
SAS creates the following table:
IS FALSE Example Output Table
IS FALSE Example Output Table

See Also

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