Does SQL Server 2005 have an equivalent to MySql’s ENUM data type?
Use one or more scalar UDFs?
One per constant:
One per enum:
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).