I am new to the SQL server world. Hope someone will kindly give me answer
to the following situation. Thanks in advance.

Among many there are 3 columns in a table:
ExemptEmployee (bit, Not Null)
AnnualSalary (Money, Null)
HourlyWage (Money, Null)

If ExemptEmployee is True, then AnnualSalary field must have a value and
HourlyWage field must be Null. If ExemptEmployee is False, then AnnualSalary
field must be Null and HourlyWage field must have a value.

Is there any easy way of enforcing the logic using constraint? If so, how
would write the constraint?


Jesse