SQL Server equivalent to MySQL enum data type?

Question

I have been trying to find out if the data-type enum exists in SQL Server 2008 like the one you have in MySQL.

Answer 1

It doesn't. There's a vague equivalent:

mycol VARCHAR(10) NOT NULL CHECK (mycol IN('Useful', 'Useless', 'Unknown'))