UFN_TARGETGIFTRANGE_GETRANAGE

            create function dbo.UFN_TARGETGIFTRANGE_GETRANAGE(@ID uniqueidentifier)
            returns nvarchar(50) 
            with execute as caller
            as begin
                declare @RANGE nvarchar(50);

                select 
                    @RANGE = RANGE 
                from 
                    dbo.TARGETGIFTRANGE
                where 
                    ID = @ID;

                return @RANGE;
            end