Re: Re: SSN's possible new Y2K problem?

This is correct. They are recycled 25-50 years after a person's death (From SSN people here in Houston).

Additionally if there are 1 billion active SSN's out there, then the 1 billonth would be alphanumeric 00a-000-0000

Stick with VARCHAR(9)

--Kristofer
Updated: Forgot my p tags

Comment on Re: Re: SSN's possible new Y2K problem?

Replies are listed 'Best First'.
Re: Re: Re: SSN's possible new Y2K problem? by seattlejohn (Deacon) on Aug 16, 2002 at 23:16 UTC
Additionally if there are 1 billion active SSN's out there, then the 1 billonth would be alphanumeric 00a-000-0000 SSNs are not assigned sequentially, and certain digit sequences are considered invalid. The first three digits indicate in what state or administrative region the SSN was assigned, and the next two indicate in what group it was assigned. Here is an explanation.	[reply]