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

delete row:ISNULL(Qty)

Output: Deletes any row in which the value in the Qty column is null.

delete value:ISNULL(column_string)

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