si_carter_987654321 wrote:

> I have two almost identical sets of records, what would be the most efficient way of detecting records that are different in the table based on a single column?

If you only want to view the difference, I recommend using FBCopy with
XH option. It creates a nice HTML table showing both old and new values.

Otherwise, do the inner join on key columns and use IS DISTINCT FROM on
all non-key columns.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================