Hi, there is no enum datatype in MS SQL. You may use a check constraint. Something like that: CREATE TABLE tblTest ( ID INT PRIMARY KEY IDENTITY, ANormalColumn VARCHAR(10) DEFAULT ('') NOT NULL, RestrictedColumn INT CHECK (RestrictedColumn IN (1,2,3) ) The first of the following inserts is OK, while the latter throws an error: INSERT INTO tblTest (ANormalColumn, RestrictedColumn) VALUES ('A', 1) INSERT INTO tblTest (ANormalColumn, RestrictedColumn) VALUES ('B', 4) -sa -- http://www.livingit.de http://www.not2long.net