if you want to remove duplicate records with ntext,text and image datatype .please do the below link stap. http://www.codegroups.com/blog/index.php/deleting-duplicate-records-from-table-with-text-ntext-or-image-data-type/ I hope this is help ! Regards, Shaileshk