USP_RE7APPEALSEARCH

      create procedure dbo.USP_RE7APPEALSEARCH
      (
      @DESCRIPTION nvarchar(255) = null,
      @IDENTIFIER nvarchar(20) = null,
      @STARTDATE datetime = null,
      @ENDDATE datetime = null,
      @ISINACTIVE bit = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;

      set @DESCRIPTION = '%' + isnull(@DESCRIPTION, '') + '%';
      set @IDENTIFIER = '%' + isnull(@IDENTIFIER, '') + '%';

      select top (@MAXROWS)
      [LOCALID] [ID],
      [NAME] [IDENTIFIER],
      [DESCRIPTION],
      [STARTDATE],
      [ENDDATE],
      cast((case [ISACTIVE] when 1 then 0 else 1 end) as bit) [ISINACTIVE]
      from [dbo].[RE7_APPEAL]
      where
      (@DESCRIPTION is null or ([DESCRIPTION] like @DESCRIPTION))
      and
      (@IDENTIFIER is null or ([NAME] like @IDENTIFIER))
      and
      (@STARTDATE is null or ([STARTDATE] = @STARTDATE))
      and
      (@ENDDATE is null or ([ENDDATE] = @ENDDATE))
      and
      (@ISINACTIVE is null or (cast((case [ISACTIVE] when 1 then 0 else 1 end) as bit) = @ISINACTIVE))
      and
      (@SYSTEMRECORDID is null or ([LOCALID] = @SYSTEMRECORDID));

      return 0;