Versions Compared

Old Version 5

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (a.jansen)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite

ISNULL


This function checks Checks whether a value is unknown. 


Syntax

Code Block
ISNULL ( expression )



Input
  • expression - Expression that is checked.


Return type

  • boolean - TRUE of the attribute is unknown, FALSE otherwise


Examples

Suppose the following data model.


Person.namePerson.SequenceNumber
“Bob”654
“Jane”?
Active PersonExpressionResultType
BobISNULL ( Person.SequenceNumber )FALSEboolean
JaneISNULL ( Person.SequenceNumber )TRUEboolean


Back to top