dinhunzvi Junior Poster 103 posts since Jul 2010 Reputation Points: 0 [?] Q&As Helped to Solve: 8 [?] Skill Endorsements: 0 [?] 0 1 Year Ago i have a problem. i have a table that has one column that should accept one of a set of defined values. i know in MySQL i use the following command to create the table: CREATE TABLE tblstudents ( studentID int( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT, lastName VARCHAR( 20 ) NOT NULL, initial CHAR( 1 ), firstName VARCHAR( 20 ) NOT NULL, gender ENUM( 'Male', 'Female' ) NOT NULL, PRIMARY KEY studentID ( studentID ) ) what command do i use in SQL Server?