>I'm switching an index to a primary and am getting a duplicate index message. How can I find the duplicates amoung 1000's without
>looking through them all?
Select IDField, count(IDField) as nCount
from MyTable
group by IDField
having nCount>1
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.