UFN_BUILDFULLADDRESS_WPREALESTATE
Return
| Return Type |
|---|
| nvarchar(250) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADDRESS | nvarchar(300) | IN | |
| @CITY | nvarchar(100) | IN | |
| @STATE | nvarchar(200) | IN | |
| @ZIP | nvarchar(20) | IN |
Definition
Copy
CREATE function dbo.UFN_BUILDFULLADDRESS_WPREALESTATE(
@ADDRESS nvarchar(300),
@CITY nvarchar(100),
@STATE nvarchar(200),
@ZIP nvarchar(20)
)
returns nvarchar(250)
with execute as caller
begin
declare @STR nvarchar(250) = @ADDRESS+NCHAR(13)+NCHAR(10)+@CITY+NCHAR(44)+NCHAR(32)+@STATE+NCHAR(32)+NCHAR(32)+@ZIP;
set @STR = dbo.UFN_ADDRESS_CLEAN(@STR);
return @STR;
end