CLR Reference: Zip Code
-
Request
a trial -
Request
a demo -
Request
a quote
CLR Data Masking Components
Open Navigation Article
CLR Reference: Zip Code
-
Request
a trial -
Request
a demo -
Request
a quote
Zip Code
CLR function
SQLCLR:
SELECT [dbo].[ZipCodeRandom] (<@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].[ZipCodeRandom] ('K1A 0B1')
×
![Enlarged Picture]()
CLR Reference: Zip Code
Download Manual
