Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

Excerpt

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

D s
snippetBasic

...

Output: Deletes any row in which the value in the the Qty column 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

...

  • 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

...

Include Page
EXAMPLE - Type Functions
EXAMPLE - Type Functions

D s also
labeltype