compare(string1,string2[,codes])

Compares the values of two string variables or constants, and returns a whole number. The optional codes are expressed as a single argument within a single pair of quotes. The returned values are 1 if equal and 0 if not equal unless code 'L' is specified. The codes are not case sensitive.
  • L
    : Lexical comparison, returning -1 if string1 is lexically less than string2, 0 if they are equal, and +1 if string1 is lexically greater.
  • S:
    Short compare: if string2 is shorter than string1, compare only up to the length of string2.
  • T:
    Before comparing, trim leading and trailing spaces from string1.
  • U:
    Ignore case
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.