UFN_ADDRESS_FIXSTANDARDIZATION

create function dbo.UFN_ADDRESS_FIXSTANDARDIZATION(
 @ADDRESSBLOCK nvarchar(150)
)
returns nvarchar(150)
as
begin 
  declare @ADDRESSSTANDARDIZATIONENABLED bit, @FIELDCAPITALIZATIONENABLED bit;

  select @ADDRESSSTANDARDIZATIONENABLED = ADDRESSSTANDARDIZATIONENABLED,
         @FIELDCAPITALIZATIONENABLED = FIELDCAPITALIZATIONENABLED
  from dbo.CONSTITUENTBUSINESSRULESSETTINGS

  if @FIELDCAPITALIZATIONENABLED = 1 --first capitalize the address

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

  if @ADDRESSSTANDARDIZATIONENABLED = 1 --standardize the address

      set @ADDRESSBLOCK = dbo.UFN_ADDRESS_STANDARDIZE(@ADDRESSBLOCK);

  return @ADDRESSBLOCK
end