UFN_CLEANCONSTITUENTSTRINGS
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FIRSTNAME | nvarchar(50) | IN | |
| @KEYNAME | nvarchar(100) | IN | |
| @ADDRESSBLOCK | nvarchar(150) | IN | |
| @POSTCODE | nvarchar(12) | IN |
Definition
Copy
CREATE function dbo.UFN_CLEANCONSTITUENTSTRINGS (
@FIRSTNAME nvarchar(50),
@KEYNAME nvarchar(100),
@ADDRESSBLOCK nvarchar(150),
@POSTCODE nvarchar(12)
)
returns @CLEANSTRINGS table (
FIRSTNAME nvarchar(50),
KEYNAME nvarchar(100),
STREETNUMBER nvarchar(12),
STREETNAME nvarchar(150),
POSTCODE nvarchar(12)
)
begin
insert into @CLEANSTRINGS
select FIRSTNAME, KEYNAME, STREETNUMBER, STREETNAME, POSTCODE
from dbo.UFN_CLEANCONSTITUENTSTRINGS_2(@FIRSTNAME, null, @KEYNAME, @ADDRESSBLOCK, @POSTCODE);
return
end