I want to declare a datatype like this: create table abc ( days enum('sat','sun','mon') ) How can i do that? I know that mysql, oracle supports this type of database but what about sql server 2005? Also can i use user defined datatype for this kind of problem? if so then please tell me how. Thanks. TFR