UFN_BBIS_ADDRESSINFORMATION_STANDARDIZE

CREATE function dbo.UFN_BBIS_ADDRESSINFORMATION_STANDARDIZE(
 @ADDRESSBLOCK nvarchar(150),
 @CITY nvarchar(50),
 @COUNTRYID uniqueidentifier
)
returns @RESULTS table(
ADDRESSBLOCK nvarchar(150),
CITY nvarchar(50)
)
begin 
  declare @ADDRESSSTANDARDIZATIONENABLED bit, @FIELDCAPITALIZATIONENABLED bit;

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

  if @FIELDCAPITALIZATIONENABLED = 1 --first capitalize the address and city

  begin
     -- we need to call the same capitalization UFN as the one used for names.  This way, mcdonald would 

     -- get capitalized correctly: McDonald

     select @ADDRESSBLOCK= LASTNAME, @CITY=FIRSTNAME FROM dbo.UFN_CONSTITUENT_CAPITALIZENAMES(@ADDRESSBLOCK, @CITY, NULL, NULL,NULL)
  end

  if @ADDRESSSTANDARDIZATIONENABLED = 1 --standardize the address

  begin
    set @ADDRESSBLOCK = dbo.UFN_ADDRESS_STANDARDIZE(@ADDRESSBLOCK,@COUNTRYID);
  end
  insert into @RESULTS 
  select @ADDRESSBLOCK as ADDRESSBLOCK, 
  @CITY as CITY

    return
end