Originally posted by andrewst
> ALTER TABLE appointee
> ADD CONSTRAINT chk_nominee_age CHECK (age < 18);
Of course, Age is a rather silly column to hold in a table, because it
is meaningless by itself. Without knowing the date when the Age value
was entered/updated, it tells you only the the person is "at least" 17
(e.g.); by now he.she could be 18, 19, 42, ... What you should really
hold is date of birth (or year of birth or whatever suits your needs).
--
Posted via http://dbforums.com
Received on Sat Jun 14 2003 - 08:09:53 CDT
