Caché MultiValue Basic Reference
Performs a less than comparison on elements of two dynamic arrays.
function compares each corresponding numeric element from two dynamic arrays and determines which value is lesser. It returns a dynamic array of boolean values in which each element comparison is represented. It returns a 1 if the dynarray1
element value is less than the dynarray2
element value. It returns a 0 if the dynarray1
element value is equal to or greater than the dynarray2
removes signs and leading and trailing zeros from element values before making the comparison. If an element value is missing or has a null string or non-numeric value, LTS
assigns it a value of 0 for the purpose of this comparison.
If the two dynamic arrays have different numbers of elements, the returned dynamic array has the number of elements of the longer dynamic array. By default, the shorter dynamic array is padded with 0 value elements for the purpose of comparison. You can also use the REUSE
function to define behavior when specifying two dynamic arrays with different numbers of elements.
For two elements to be compared, they must be on the same dynamic array level. For example, you cannot compare a value mark (@VM) dynamic array element to a subvalue mark (@SM) dynamic array element.
The following example uses the LTS
function to return a less than comparison for each of the elements in dynamic arrays a
! returns 0ý0ý1ý0