Ne_or_one_null

ordering-functions not equals or one side has null values

syntax

  • ne_or_one_null(a, b)

definition

ne_or_one_null(a, b) results in a boolean data-item indicating if the values of data item a are not equal to the corresponding values of data item b or if the corresponding values of data items a or b are null.

description

The comparison between two missing values (null = null) results in the value False.

applies to

Data items with Numeric, Point, or string value-type

conditions

  1. Domain of the arguments must match or be void (literals or parameters can be compared to data items of any domain).
  2. Arguments must have matching:

example

1. attribute<bool> neAB (CDomain) := ne_or_one_null(A, B);

see also