Dear Friends,

FieldName DataType Check Constraint

1)Percentage Integer 0-100%, if Area = 1,
Otherwise must be null
2)Area Bit

Constraint

([Percentage] >= 0 and [Percentage] <= 100)

How to write the above constraint in SQL Server2000? I have finished half
part.If anyone knows the remainning constraint...
Please let me know..

Advance thanks,
Joe