UFN_MEMBERSHIPCANCELLATIONCODE_GETTRANSLATION

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

                    select @DESC = CODE + ' - ' + DESCRIPTION
                    from dbo.MEMBERSHIPCANCELLATIONCODE
                    where ID = @ID;

                    return @DESC;
                end