UFN_ADDRESS_FORMAT_US
Formats an address in the United States format.
Return
| Return Type |
|---|
| nvarchar(250) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADDRESSID | uniqueidentifier | IN | |
| @ADDRESSBLOCK | nvarchar(150) | IN | |
| @CITY | nvarchar(50) | IN | |
| @STATEID | uniqueidentifier | IN | |
| @POSTCODE | nvarchar(12) | IN | |
| @COUNTRYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_ADDRESS_FORMAT_US
(@ADDRESSID uniqueidentifier,@ADDRESSBLOCK nvarchar(150),@CITY nvarchar(50),@STATEID uniqueidentifier,@POSTCODE nvarchar(12),@COUNTRYID uniqueidentifier)
returns nvarchar(250) with execute as caller as begin
declare @STATE nvarchar(100)='';
declare @STATEABBR nvarchar(50)='';
select @STATE=DESCRIPTION, @STATEABBR=ABBREVIATION from dbo.STATE where ID = @STATEID;
declare @STR nvarchar(250)=@ADDRESSBLOCK+NCHAR(13)+NCHAR(10)+@CITY+NCHAR(44)+NCHAR(32)+@STATEABBR+NCHAR(32)+NCHAR(32)+@POSTCODE;
set @STR = dbo.UFN_ADDRESS_CLEAN(@STR);
return @STR;
end