Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Array data types : 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