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