Re: DB required to list multiple D.I.V.O.R.C.E.S. & Re-marriages
From: <paul.vernon_at_ukk.ibmm.comm>
Date: Fri, 21 Dec 2001 11:16:07 +0000
Message-ID: <9vv8be$pjc$1_at_sp15at20.hursley.ibm.com>
CHECK (marriage_date <= divorce_date OR divorce_date IS NULL),
^^^^^^^^^^^^^^^^^^^^^^
Don't you just love NULLs
Regards
Paul Vernon
P.S. If this gets sent in HTML, I appologise. My News reader doesn't always do what I say, but it will soon be brought to task. Received on Fri Dec 21 2001 - 12:16:07 CET
Date: Fri, 21 Dec 2001 11:16:07 +0000
Message-ID: <9vv8be$pjc$1_at_sp15at20.hursley.ibm.com>
CHECK (marriage_date <= divorce_date OR divorce_date IS NULL),
^^^^^^^^^^^^^^^^^^^^^^
Don't you just love NULLs
Regards
Paul Vernon
P.S. If this gets sent in HTML, I appologise. My News reader doesn't always do what I say, but it will soon be brought to task. Received on Fri Dec 21 2001 - 12:16:07 CET