Thanks Gila!

So the code should read like this?

ALTER TABLE TableName

ADD CONSTRAINT chkcnst CHECK((SexColumn='Female' AND PregnancyFlagColumn = 'Y') OR PregnancyFlagColumn = 'N') ;

GO

ok so here is what i came up with, can you guys tell me how it looks?

A death date preceding a birth date

ALTER TABLE TableName

ADD CONSTRAINT constraintname

CHECK (death_date...