View Source

The NULL function generates null values.

The ISNULL function tests for the presence of null values. See ISNULL Function.
Null values are different from missing values.
- To test for missing values, see ISMISSING Function.

null()

Output: Returns a null value.

if((isnull(FirstName) || isnull(LastName)), null(), 'not null') as:'status'

Output: If there are null values in either the FirstName or LastName column, generate a null value in the status column. Otherwise, the returned value is not null.

There are no arguments for this function.

Example - Type check functions