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