Question: > 
> **Possible Duplicate:**  
> 
> [Does SQL Server 2005 have an equivalent to MySql’s ENUM data type?](https://stackoverflow.com/questions/262802/does-sql-server-2005-have-an-equivalent-to-mysqls-enum-data-type) 
> 
> 
> 

Is there any way to define ENUM in SQL Server 2005?

I have fixed values which I need to use in procedures and functions.

Answer: 
Use one or more scalar UDFs?

One per constant:

* `dbo.CONST_Bicycle` returns 1
* `dbo.CONST_Car` returns 2

One per enum:

* `dbo.CONST_Types('Bicycle')` returns 1
* `dbo.CONST_Types('Car')` returns 2

Or use a table with ID, Name per enum

Use a client side enum to match this (perhaps with validation against the table solution)

There is **no** quick or clean way to do this like there is in .net (as per your comment).
SQL Server supports user defined data types. You might want to do something with [CREATE TYPE (Transact-SQL)](http://msdn.microsoft.com/en-us/library/ms175007.aspx). But I don't know even if it is possible through User defined datatypes and not aware of its pros and cons. May be someone else will throw more light on it.