Try something like this:


SELECT SSN FROM TableName GROUP BY SSN HAVING Count([SSN]) > 1 AND SSN = SSNNumberToCheck;



Regards,

------------------

Serge

Software Developer
[email protected]
[email protected]