BOOLEAN Expressions
You can now use boolean value expressions within SQL expressions wherever an expression appears in SQL syntax.
boolean_expression::=

Description of the illustration boolean_expression.gif
condition::=

Description of the illustration condition.gif
boolean_test_condition::=

Description of the illustration boolean_test_condition.gif
Use boolean_expression to evalute the input and return one of the following boolean values :
-
IS TRUE -
IS NOT TRUE -
IS FALSE -
IS NOT FALSE -
IS NULL -
IS NOT NULL
See Also: About SQL Expressions