UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS

Returns a formatted address.

Return

Return Type
nvarchar(300)

Parameters

Parameter	Parameter Type	Mode
@ADDRESSBLOCK	nvarchar(150)	IN
@UNITNUMBER	nvarchar(25)	IN
@CITY	nvarchar(50)	IN
@STATEABBR	nvarchar(100)	IN
@POSTCODE	nvarchar(12)	IN

Definition

Copy



            CREATE function dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS (
                @ADDRESSBLOCK nvarchar(150),
                @UNITNUMBER nvarchar(25),
                @CITY nvarchar(50),
                @STATEABBR nvarchar(100),
                @POSTCODE nvarchar(12)
            )
            returns nvarchar(300)
            with execute as caller
            as begin
                declare @STR nvarchar(250)=@ADDRESSBLOCK+NCHAR(32)+@UNITNUMBER+NCHAR(13)+NCHAR(10)+@CITY+NCHAR(44)+NCHAR(32)+@STATEABBR+NCHAR(32)+@POSTCODE;
                set @STR = dbo.UFN_ADDRESS_CLEAN(@STR);
                if unicode(right(@STR,1)) = 44 set @STR = rtrim(substring(@STR,1,len(@STR)-1))
                return @STR;
            end