IsNotNull function

Returns true when an expression does not evaluate to the null value.

Namespace

Global. No namespace qualifier required.

Input

any object or expression

Output

boolean (true/false)

Example

If a contains the null, b contains string value and c contains number 999 then If the input column does not contain a null, the output column contains the value of the input column. If the input column does contain a null, then the output column contains the string null. In the below examples, col1 is null, col2 is value, col3 is 999 and col4 is null.