IS TRUE Predicate

Tests for a true value.

Syntax

Arguments

Details

Comparisons

Example

Syntax

(expression) IS [NOT] TRUE

Arguments

expression

specifies any valid SQL expression.

See	<sql-expression>
	FedSQL Expressions

Details

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

Comparisons

The IS FALSE predicate tests for false values.

Example

Table: WORLDCITYCOORDS

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

SAS creates the following table:

IS TRUE Example Output

IS TRUE Predicate

Syntax

Arguments

expression

Details

Comparisons

Example

See Also