View Source

The ISNULL function tests whether a column of values contains null values. For input column references, this function returns true or false.

The NULL function generates null values. See NULL Function.
Null values are different from missing values.
- To test for missing values, see ISMISSING Function.

isnull(Qty)

Output: Returns true if the value in the Qty column is null.

isnull(column_string)

Argument	Required?	Data Type	Description
column_string	Y	string	Name of column or string literal to be applied to the function

Name of the column or string literal to be tested for null values.

Required?	Data Type	Example Value
Yes	String literal or column reference	`myColumn`

Valid data type strings: