With respect to the comment about no ENUM in SQL Server, there are CHECK CONSTRAINTS, which might be worth exploring... Scott