>Thanks Sergey, that helps alot to find the dups.
>
>You wouldn't happen to know an easy fix to remove the extra dups from the columns?

Assuming that the first 2 updates happen on the same date and you want to keep the first one, try

SELECT LEFT(Narrative, CHARINDEX(LEFT(Narrative,14), Narrative, 20)-1)
	FROM mytable
	WHERE Narrative LIKE '%the following images were imported%the following images were imported%'