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

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