-
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Zip Code Dynamic
CLR Data Masking Components
Open Navigation Article
-
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Zip Code Dynamic
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
