Are you sure they are duplicates? There are no trailing/leading spaces? Only standard ASCII characters are used (there e.g. no different unicode a's or whatever oher characters - a common problem when data from different websites is copied into database fields or form controls)?
Easiest way to check this: Copy some offending query results into Excel and compare field values from different rowsCode:=(Row1FieldValue = Row2FieldValue)