Actually, there is an object in SQL Server called a Check Constraint. You can use it to put all kinds of restrictions on columns. Here's what you would use: ... Here's some test inserts to demonstrate how it would work: ... Hope this works for you. Good luck!