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 r096

D toc

Excerpt

The NULL function generates null values.

  • The ISNULL function tests for the presence of null values. See ISNULL Function.
  • Null values are different from missing values.

D s lang vs sql

D s
snippetBasic

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:null()

null()

Output: Returns a null value.

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: if((isnull(FirstName) || isnull(LastName)), null(), 'ok') as:'status'

if((isnull(FirstName) || isnull(LastName)), null(), 'not null') as:'status'

Output: If there are null values in either the FirstName or LastName column, generate a null value in the status column. Otherwise, the returned value is not null.

D s
snippetSyntax

There are no arguments for this function.

D s
snippetExamples

Example - Type check functions

Include Page
EXAMPLE - Type Functions
EXAMPLE - Type Functions

D s also
labeltype