UFN_RESOURCECATEGORY_GETNAMEFORPD

                create function dbo.UFN_RESOURCECATEGORY_GETNAMEFORPD
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(50) 
                as
                begin
                    declare @s nvarchar(50);
                    if @ID = '99999999-9999-9999-9999-999999999999'
                        select @s = 'All resource categories'
                    else
                        select @s = DESCRIPTION from dbo.RESOURCECATEGORYCODE where ID = @ID

                    return @s;
                end