When this option is off, Analyzer compares character fields or expressions that are not of equal length, based on the shortest character field or expression. For example, “AB” is considered to be equal to “ABC” and “ABLMNOP”.
If you turn this option on, Analyzer compares character fields or expressions based on their full length, which must be exactly the same. Two strings of different lengths, therefore, are never equal. For example, “AB” is not considered equal to “ABC”.
SET EXACT ON|OFF