We have a Enums class that contains all enums for the solution and some of these enum values actually make their way into the application database. In some queries it would be much better to show the 'text value' of an enum rather than it's integer value. Does anyone know if there is any way of doing such a thing in SQL Server 2005 now that CLR/managed code is supported? If there is can you point me to a reference or two.
Cheers, Peter
Well I haven't tried this yet but I must say it seems easy - stunning!!!
Once again, thanks for the prompt response.