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


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


ArgumentRequired?Data TypeDescription
column_stringYstringName 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 TypeExample Value
YesString literal or column referencemyColumn

Valid data type strings:

Example - Type check functions