In a recent effort to clean up duplicates in my contacts I came across a script to assist me.
In my situation I have some contacts that have had the company name inserted as the first/last name.
SELECT id, [Company], [Title], [First Name], [Middle Name], [Last Name] FROM [OutlookContacts] WHERE Company LIKE '%' + [First Name] + '%' ORDER BY [Last Name]
In my case almost all of the records could be modified to null the first and last name but if you need to limit the update modify the WHERE statement accordingly.
UPDATE [OutlookContacts] SET [First Name] = NULL, [Last Name] = NULL WHERE Company LIKE '%' + [First Name] + '%'
Last Updated on October 26, 2015