SUBSTRNG With Modifier (AND) - trillium_quality - trillium_discovery - Latest

The AND modifier is used with the SUBSTRNG routine to take both comparisons into consideration. This routine requires two fields defined from each record: field 1 is the first field, field 2 is the second field. It performs two comparisons:

1. Compares field 1 from record 1 with field 2 from record 2 and detects whether field 1 is an exact match of field 2.
2. Compares field 1 from record 2 with field 2 from record 1 and detects whether field 1 is an exact match of field 2.

This routine returns a score by taking both comparisons into consideration.