The ISMISSING function tests whether a column of values is missing or null. For input column references, this function returns true or false.


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


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 missing values.


Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - Type check functions