UFN_ACQUISITIONLIST_CONCATENATEADDRESSLINES

Utility function to concatenate address lines when importing a member of a BBDM acquisition list.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESSLINE1	nvarchar(max)	IN
@ADDRESSLINE2	nvarchar(max)	IN

Definition

Copy



CREATE function dbo.[UFN_ACQUISITIONLIST_CONCATENATEADDRESSLINES]
(
  @ADDRESSLINE1 nvarchar(max),
  @ADDRESSLINE2 nvarchar(max)
)
returns nvarchar(max)
as
  begin
    declare @ADDRESSBLOCK nvarchar(max) = null;

    set @ADDRESSLINE1 = isnull(ltrim(rtrim(@ADDRESSLINE1)), '');
    set @ADDRESSLINE2 = isnull(ltrim(rtrim(@ADDRESSLINE2)), '');

    if len(@ADDRESSLINE1) > 0 and len(@ADDRESSLINE2) > 0
      set @ADDRESSBLOCK = @ADDRESSLINE1 + char(13) + char(10) + @ADDRESSLINE2
    else if len(@ADDRESSLINE1) > 0
      set @ADDRESSBLOCK = @ADDRESSLINE1
    else if len(@ADDRESSLINE2) > 0
      set @ADDRESSBLOCK = @ADDRESSLINE2;

    return @ADDRESSBLOCK;
  end