UFN_RE7CONSTITUENTRATING_GETCONSTITUENTRATINGCATEGORY

create function dbo.UFN_RE7CONSTITUENTRATING_GETCONSTITUENTRATINGCATEGORY(@ID int)
returns  nvarchar(510)
as
begin
  return (
          select 
            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 [CR].[LOCALID] = @ID
        )
end