An example using enum in SQL 2005

userRole varchar(10) not null CHECK(userRole in ('admin','normal','other')) default 'normal'