>Hello... I'm having problems with my logic here so I was looking for a little help.
>
>I need to search a table for people with the same last name's and same dob. However, the name field is applicant = lname, fname mi. What's the best way to do this???
>
>( I don't want to search by ssn, b/c were looking for people trying to get around the system by using a different ssn and applying at different times)
>
>Thanks,
>Sunshine

You need a GROUP BY. Something like this:

select lname, fname, mi, birthday, count(*) as repeat;
  from people;
  group by lname, fname, mi, birthday;
  having repeat > 1