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

isnull(Qty)

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

isnull(column_string)


ArgumentRequired?Data TypeDescription
column_stringYstringName of column or string literal to be applied to the function

column_string

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