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
- Domain of the arguments must match or be void (literals or parameters can be compared to data items of any domain).
- Arguments must have matching:
example
1. attribute<bool> neAB (CDomain) := ne_or_one_null(A, B);