UFN_RESPONSECATEGORY_GETDESCRIPTION

            create function dbo.UFN_RESPONSECATEGORY_GETDESCRIPTION(@ID uniqueidentifier)
            returns nvarchar(100)
            with execute as caller
            as begin
                    declare @NAME nvarchar(100);

                    select
                        @NAME = RC.NAME
                    from
                        dbo.RESPONSECATEGORY as RC
                    where RC.ID = @ID;

                    return @NAME;
            end