UFN_MEMBERSHIPLEVELTERM_ISUPGRADEABLE

        CREATE function dbo.UFN_MEMBERSHIPLEVELTERM_ISUPGRADEABLE(@MEMBERSHIPLEVELTERMID uniqueidentifier)
        returns bit
        as begin
            declare @ISUPGRADEABLE bit = 0

        select
          @ISUPGRADEABLE = case when MLT.ID IS NULL then 0 else 1 end
          from
          dbo.MEMBERSHIPLEVELTERM MLT
          inner join dbo.MEMBERSHIPLEVELTERM MLT2 on MLT.LEVELID = MLT2.LEVELID
          inner join dbo.MEMBERSHIPLEVEL ML on MLT2.LEVELID = ML.ID
          inner join dbo.MEMBERSHIPPROGRAM MP on ML.MEMBERSHIPPROGRAMID = MP.ID
        where
          MLT2.ISACTIVE = 1
          and (MP.PROGRAMTYPECODE != 2 and MLT.SEQUENCE < MLT2.SEQUENCE)
                and MLT.ID = @MEMBERSHIPLEVELTERMID

      return @ISUPGRADEABLE

        end