UFN_BBIS_NAMEFIELDS_CAPITALIZE

CREATE function dbo.UFN_BBIS_NAMEFIELDS_CAPITALIZE(
-- Only first name and last name are currently available on the BBIS registration form.

@LASTNAME nvarchar(50),
@FIRSTNAME nvarchar(50)
)
returns @RESULTS table(
LASTNAME nvarchar(150),
FIRSTNAME nvarchar(50)
)
begin 
  declare @FIELDCAPITALIZATIONENABLED bit;

  select @FIELDCAPITALIZATIONENABLED = FIELDCAPITALIZATIONENABLED
  from dbo.CONSTITUENTBUSINESSRULESSETTINGS

  if @FIELDCAPITALIZATIONENABLED = 1
    begin
      insert into @RESULTS 
      select LASTNAME,FIRSTNAME FROM dbo.UFN_CONSTITUENT_CAPITALIZENAMES(@LASTNAME, @FIRSTNAME, NULL, NULL,NULL)
    end
  else
    begin
        insert into @RESULTS 
      select @LASTNAME,@FIRSTNAME
    end

  return
end