CLR Reference: Zip Code Dynamic
-
Request
a trial -
Request
a demo -
Request
a quote
CLR Data Masking Components
Open Navigation Article
CLR Reference: Zip Code Dynamic
-
Request
a trial -
Request
a demo -
Request
a quote
Zip Code Dynamic
CLR function
SQLCLR:
SELECT [dbo].[ZipCodeDynamic] (<@ZipCode, nvarchar(4000)>)
Expected input
Data: Valid USA or Canadian Zip Code
Expected output
Generic USA or Canadian Zip Code (depends on input) (nvarchar(MAX))
Error handling
Returns an empty string when passing empty or NULL value. Fails on invalid zip code format
Example
SQLCLR:
SELECT [dbo].[ZipCodeDynamic] ('11302')
×
![Enlarged Picture]()
CLR Reference: Zip Code Dynamic
Download Manual
