ISNOTTRUE scalar function

The ISNOTTRUE function returns TRUE when the truth value of the value returned by input expression is FALSE or NULL and FALSE when the truth value is TRUE.

The schema is SYSIBM.

expression

An expression that returns the Boolean value (or representation of a Boolean value) that is to be evaluated by the function. The data type of the returned value must be of one of the following data types (SQLSTATE 42884):

BOOLEAN
SMALLINT, INTEGER, BIGINT (binary integer)
DECFLOAT (floating decimal)
CHAR or VARCHAR (string)
GRAPHIC or VARGRAPHIC (graphic; applies only to a Unicode database)

Non-Boolean values are implicitly cast to Boolean values as described in Boolean values.

If the returned value is a string, it must be a valid representation of a Boolean value as described in Boolean values (SQLSTATE 22018).

The data type of the result is BOOLEAN.

Examples

Example 1: The following statement returns a value of data type BOOLEAN with the value FALSE.
```
   values ISNOTTRUE(1)
```
Example 2: The following statement returns a value of data type BOOLEAN with the value TRUE.
```
   values ISNOTTRUE('NO')
```
Example 3: The following statement returns a value of data type BOOLEAN with the value FALSE.
```
   values ISNOTTRUE('Yes')
```
Example : The following statement returns a value of data type BOOLEAN with the value TRUE.
```
   values ISNOTTRUE(NULL)
```