>>They would have different IDs. The situation I have is when people call in to verify their account, I need to have the operator perform additional verification steps if identical names fall on multiple accounts. Doesn't account for the Mike vs. Michael, but it's a start. Thanks, glad I still got it after working with ORMs for years.
>
>If they would have different IDs, then yes, a subquery is necessary. So you still have the skills :)
>
>On "Mike" vs "Michael"....SQL Server Integration Services has a nice fuzzy lookup capability - though integrating it with a .NET app requires a bit of work.
>
>SQL Server has SOUNDEX though admittedly I've never tried it.
We've messed with SOUNDEX a bit and it seemed to work well, but I don't remember enough of what we did to comment on it. I'll figure out the fuzzy lookup stuff if requested.