Page tree

Versions Compared

Key

  • 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

Excerpt

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

D s
snippetBasic

D code

delete row:ISNULL(Qty)

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

D s
snippetSyntax

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

column_string

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
snippetusage

 

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
snippetExamples

Example - Type check functions

Include Page
EXAMPLE - Type Functions
EXAMPLE - Type Functions

D s also
labeltype