Anthony wrote: > If you are just interested in "repeats" in a single column this should work... > > select Count(IDF), IDF from TableName > where Count(IDF) > 1 > group by IDF Close. Given that the "where" is on a aggregated column (count(IDF)) you can't use "where". You need "having", which is applied AFTER the aggregates (including 'group by'). So select Count(IDF), IDF from TableName group by IDF having Count(IDF) > 1 should tell you any duplicate IDFs. Hope this helps! Paul.