On Thu, May 22, 2003 at 10:50:10 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com> wrote:
> Is there a better way to do this?
How are you using the data?
Having NULL represent unknown is a reasonable way to do this.
Even if you delete the date entries, when you join the table back
with your main id table, you are most likely want to use an outer
join which will result in the missing birthdates being represented
as nulls anyway.