One of the two below:/************************************************************ * Code formatted by SoftTree SQL Assistant © v6.2.112 * Time: 11/16/2012 8:00:29 AM ************************************************************/-- 1SELECT Gender, GivenName, SurnameFROM HugeNamesWHERE NameID IS NOT NULLGROUP BY Gender, GivenName, Surname-- 2;WITH cteAS( SELECT GivenName, Surname, MiddleInitial, NameID, ROW_NUMBER() OVER ( PARTITION BY GivenName,Surname,MiddleInitial ORDER BY (SELECT NULL) ) AS RN FROM HugeNames WHERE RTRIM(LTRIM(GivenName)) LIKE '%%' AND NameID IS NOT NULL AND LTRIM(RTRIM(Surname)) LIKE '%%' AND GivenName IS NOT NULL AND Surname IS NOT NULL) SELECT u.GivenName, u.Surname, NameID, u.MiddleInitialFROM cteWHERE RN = 1ORDER BY GivenName, Surname, MiddleInitial ASC