Databasen - NULL dates

[Peter Hickman]

However will there be the case of a record for which a date is not 
appropriate?

For example a real person has a birth date but would such a thing be 
valid for a fictional character such as Michael Finnegan or Atkin Drum 
(from various nursery rhymes)?

You would seem to need a third state.

-- 
Peter Hickman.

Semantico, Lees House, 21-23 Dyke Road, Brighton BN1 3FE
t: 01273 722222
f: 01273 723232
e: peter.hickman at semantico.com
w: www.semantico.com