Try OpenEdge Now
SQL Reference
SQL Reference
:
OpenEdge SQL Language Elements
:
Data types
:
Array data types
:
Comparison
Comparison
OpenEdge SQL provides two scalar comparison operators: = and <>. Two arrays are comparable if their element data types are mutually comparable. During comparison, the elements are compared pair-wise in element order. Two arrays are equal if:
They both have the same number of elements
Each pair of elements is equal
Two arrays are not equal if:
They do not have the same number or elements
At least one pair of elements is not equal
They both have the same number of elements