UFN_DISCOUNT_GETADDRESSSELECTIONNAME

      create function dbo.UFN_DISCOUNT_GETADDRESSSELECTIONNAME
      (
        @ID uniqueidentifier
      ) 
            returns nvarchar(100)
            with execute as caller
            as
            begin

        declare @NAME nvarchar(100);
                select @NAME = NAME from dbo.IDSETREGISTER where ID = @ID
                return coalesce(@NAME, '');

            end