IS FALSE Predicate

Tests for a false value.

Syntax

Arguments

Details

Comparisons

Example

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

Table: WORLDCITYCOORDS

select city 
   from worldcitycoords
      where (latitude = 40) is false;

SAS creates the following table:

IS FALSE Example Output Table

IS FALSE Predicate

Syntax

Arguments

expression

Details

Comparisons

Example

See Also