grzegorz.mozejko (6/16/2014)

---

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

)