UFN_NAMEFIELD_FIXCAPITALIZATION

create function dbo.UFN_NAMEFIELD_FIXCAPITALIZATION( 
  @NAMEFIELD nvarchar(150)
)
returns nvarchar(150)
as
begin 
  declare @FIELDCAPITALIZATIONENABLED bit;

  select @FIELDCAPITALIZATIONENABLED = FIELDCAPITALIZATIONENABLED
  from dbo.CONSTITUENTBUSINESSRULESSETTINGS

  if @FIELDCAPITALIZATIONENABLED = 1 --capitalize the field if the setting is enabled

     set @NAMEFIELD = dbo.UFN_STRING_CAPITALIZE(@NAMEFIELD);

  return @NAMEFIELD
end