Help with SQL - query name records

Based on the requirements in your question, give this a whirl...

SELECT firstname, middlename, lastname, ID1, ID2
FROM yourtable 
WHERE  firstname = middlename AND middlename = lastname

Select allOpen in new window

>I want to query a list of all records where the first, middle and last name are the same, grouping by the same.
if there's anything missing, please spell it out.  I suspect that the above is missing some detail.

I did not articulate my  question correctly.  Let me use an example; say I have these records:

Harold L Rosenberger  123  456
Harold L Rosenberger 111 333
Mary Jones 333 444
George Washington 333 444
George Washington 555 666
George Washington 123 877
George R Washington 155 876
Gary Lee Rogers 555 120

I want these records returned:

Harold L Rosenberger  123  456
Harold L Rosenberger 111 333
George Washington 333 444
George Washington 555 666
George Washington 123 877

that works, except for one case, where the middle name is NULL.   How could I modify to handle this?

yeah, can't do a NULL = NULL, so a simple ISNULL conversion will work.  
Change 'x' to whatever floats your boat.
I modified the code block above to keep the solution in one comment.

Thanks!!

Thanks for the grade.  Good luck with your project.  -Jim