On Mon, Feb 20, 2006 at 19:24:05 +0100, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> wrote: > > I *could*, of course, use something like '999 years' as a > special value to indicate "no upper limit" figuring that no > one is going to live that long in the foreseeable future. I would think that specifying a value well beyond the current life expectency for people would be the simplest solution. Since it doesn't have to be treated like a magic value and can used consistantly with other values in the same column.