CHECK constraint help 1

[mshields]

I have 2 columns: item_price and item_cost. I need to impose a CHECK constraint at the table level where item_price can never be more than three times the item_cost and also can never be below 120% of the item_cost. Any help would be appreciated.

 

[rac2]

With MS SQL Server I think this will do it.

ALTER TABLE my_table
ADD CONSTRAINT ck_item_price
CHECK (item_price BETWEEN 1.2 * item_cost AND 3 * item_cost)