UFN_RESPONSE_GETDESCRIPTION

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

                    select
                        @DESCRIPTION = R.RESPONSE
                    from
                        dbo.RESPONSE as R
                    where R.ID = @ID;

                    return @DESCRIPTION;
            end