USP_RE7CONSTITUENTRATINGSEARCH

      create procedure dbo.USP_RE7CONSTITUENTRATINGSEARCH
      (
      @CATEGORY nvarchar(150) = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;

      if @CATEGORY is not null
        set @CATEGORY = '%' + isnull(@CATEGORY, '') + '%';

      select  top (@MAXROWS)
      [CR].[LOCALID] [ID],
      [CR].[CATEGORY],
      [C].[FULLNAME],
      case when isnull([CR].[CATEGORY], '') = '' then [C].[FULLNAME]
      else [C].[FULLNAME] + ' - ' + [CR].[CATEGORY] end [IDENTIFIER]
      from dbo.[RE7_CONSTITUENTRATING] [CR]
      left outer join dbo.[RE7_CONSTITUENT] [C] on [CR].[CONSTITUENT_LOCALID] = [C].[LOCALID]
      where
      (@CATEGORY is null or ([CR].[CATEGORY] like @CATEGORY))
      and
      (@SYSTEMRECORDID is null or ([CR].[LOCALID] = @SYSTEMRECORDID));

      return 0;