RE: Database design question

[Roger Harman <roger.harman@xxxxxxxxxxx>]

That's how we handled it at a previous employer.  Or, add a middle initial to one.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
Sent: Monday, August 28, 2017 4:24 PM
To: Midrange Systems Technical Discussion
Subject: Re: Database design question

On Mon, Aug 28, 2017 at 2:01 PM, Rob Berendt <rob@xxxxxxxxx> wrote:
> Here, Id starts out with first character of first name and 7 characters of
> last name.  I don't care if your name is Sara Hithead, you still follow
> the rules.  Divorce, marriage or other legal name changes leave you with
> the original id.

What happens if two people have the same last name and first initial?
Not meant to be snarky, just asking. Stick a number at the end?

John Y.