3.2.16. COMPARE(string1,string2[,padchar]) This function will compare string1 to string2, and return a whole number which will be 0 if they are equal, otherwise the position of the first character at which the two strings differ is returned. The comparison is case-sensitive, and leading and trailing space do matter. If the strings are of unequal length, the shorter string will be padded at the right hand end with the padchar character to the length of the longer string before the comparison. If a padchar is not specified, <space> is used. COMPARE(‘FooBar’, ‘Foobar’) –> ‘4’ COMPARE(‘Foobar’, ‘Foobar’) –> ‘0’ COMPARE(‘Foobarrr’, ‘Fooba’) –> ‘6’ COMPARE(‘Foobarrr’, ‘Fooba’, ‘r’ ) –> ‘0’
PREV NEXT