MSSQL - Enum

Some database engines support enum. Some database engines do not. Or do they? If you have ever tried to create a table with a field with an enum you will know that it is not possbile. However it is possible to simulate the same functionality using a constraint.