Ne or one null

---

title: Ne or one null permalink: /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

attribute neAB (CDomain) := ne_or_one_null(A, B);

see also

• not equals