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: 
You might want to have lookup table named LuVehicle With columns Id and Name.

Values may look like 

```
1,Bicycle
2,Car
3,MotorCycle

```

Then you can have foriegn key of Id column wherever you need in your database tables.

To retrieve the exact name of the value, you can have a simple inner join with LuVehicle table. Something like this

```
select empname, vehicleId, LuVehicle.Name from employees, LuVehicle 
where employees.vehicleId = LuVehicle.Id

```
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.