• very usefull, thx

    a small correction, when name of first index column is begining part of second index column (add comma):

    AND ( DUPE1.key_column_list+',' LIKE LEFT(DUPE2.key_column_list,

    LEN(DUPE1.key_column_list)+1)

    OR DUPE2.key_column_list+',' LIKE LEFT(DUPE1.key_column_list,

    LEN(DUPE2.key_column_list)+1)

    OR DUPE2.key_column_list=DUPE1.key_column_list

    )