CLR Reference: Zip Code Dynamic

{TOC}

"Zip Code Dynamic"

CLR function

SQLCLR:

SELECT [dbo].[UsaPhoneDynamic][dbo].[ZipCodeDynamic] (<@usaPhone,(<@ZipCode, nvarchar(4000)>)

Expected input

data:Data: numericValid USA Phoneor (canCanadian containZip separators). Length without separators from 9 to 15 digits.Code

Expected output

Generic USA Phoneor ofCanadian theZip sameCode format(depends ason inputinput) (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value. Fails on digitsinvalid countzip lesscode than 9 or more than 15format

Example

SQLCLR:

SELECT [dbo].[UsaPhoneDynamic][dbo].[ZipCodeDynamic] ('898.456.4456')('11302')