finding firstname + lastname groups

------=_Part_11398_2151858.1213904308568
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have to find the same firstname+ lastname combo in my db and see which
name appears the most so I basically need to do the following:

select name, count(name) from people group by name having count(name)>1

The problem is name is not one column but made up of firstname,
lastname...how do I do this?

Thanks!

------=_Part_11398_2151858.1213904308568
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have to find the same firstname+ lastname combo in my db and see which
name appears the most so I basically need to do the
following:<br><br>select name, count(name) from people group by name
having count(name)&gt;1<br><br>
The problem is name is not one column but made up of firstname,
lastname...how do I do this?<br><br>Thanks!<br>

------=_Part_11398_2151858.1213904308568--