UFN_CORRESPONDENCECODE_GETNAME

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

                    select @NAME = NAME from dbo.CORRESPONDENCECODE where ID = @ID;

                    if @NAME is null
                        return '';

                    return @NAME;
                end