You have two options. You can use a CHECK constraint or a trigger. The CHECK constraint has the advantage that it is validated before the data modification is actually made. With SQL Server 2000, there are two type of tiggers: AFTER (the traditional one) and INSTEADOF. Either one is capable of enforcing the rule that you need.
-Mike