GES Function

Compares the elements in two dynamic arrays.

Syntax

GES(dynArray1, dynArray2)

Syntax Elements

Return Value

A dynamic array with a structure formed by combining dynArray1 and dynArray2. Each element contains the result of comparing the corresponding elements in the original arrays. If the element in dynArray1 is greater than or equal to that in dynArray2, the element is set to 1 (true); otherwise it is set to 0 (false).

• Elements are compared character by character from left to right. Characters are compared by ASCII value (see Decimal, Hexadecimal, and ASCII Table).

  Note: If the case-insensitive option is specified or data case insensitive mode is selected (see Case Sensitivity), case is ignored when comparing characters.

• If the strings are of different lengths and each character in the shorter string matches the character at the same position in the other, the longer string is considered the greater.
• Numeric values are treated as strings.
• Non-existent elements are treated as empty strings.

See Also

EQS function, NES function, LES function.

Example

ARY1 = 1:@VM:0:@VM:-1:@AM:"Fred":@VM:"Fred":@VM:"Bert"
ARY2 = 0:@VM:0:@VM:0:@AM:"Fred":@VM:"Bert":@VM:"Fred"
NEWARY = GES(ARY1, ARY2)

Sets NEWARY to "1VM1VM0AM1VM1VM0".