Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

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

D s

D code

delete row:ISNULL(Qty)

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

D s

D code

delete value:ISNULL(column_string)

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

D s lang notes


Name of the column or string literal to be tested for null values.

  • Missing literals or column values generate missing string results.
  • Multiple columns and wildcards are not supported.

D s


Required?Data TypeExample Value
YesString literal or column referencemyColumn

Valid data type strings:

Include Page
Valid Data Type Strings
Valid Data Type Strings

D s

Example - Type check functions

Include Page
EXAMPLE - Type Functions
EXAMPLE - Type Functions

D s also