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:
   • value type
   • metric

example

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

see also

• not equals