>> i wish i could use RULE to maintain employee morale (hard to get programmers here) gonna use CHECK for now <<
For future reference, you might want to read up on CREATE ASSERTION
which is another part of Standard SQL that might show up in the future
versions of T-SQL.