There is a validation option to check for Collar name mismatch, this will return any HoleID values which are not found in the Collar table, including case differences only.

It is recommonded to convert all HoleID field values to upper case to avoid issues.