CLR Reference: State Province Dynamic

Request
a trial
Request
a demo
Request
a quote

CLR Data Masking Components

All articles

CLR Reference

Dictionary Substitution

Full Name Info Dynamic

Generic Alpha Numeric

Generic Alpha Numeric Dynamic

Generic Phone Nu

Generic Phone Nu Dynamic

Names With Gender Dynamic

State Province Dynamic

Start a Trial

CLR Data Masking Components

CLR Reference: State Province Dynamic

Request
a trial
Request
a demo
Request
a quote

API Reference

SSIS Reference

State Province Dynamic

CLR function

SQLCLR:

SELECT [dbo].[StateProvinceDynamic] (<@stateProvince, nvarchar(4000)>)

Expected input

Data: Valid USA state or territory name or code or Valid Canadian Province (based on ISO 3166-1)

Expected output

Generic USA or Canadian state/province or USA territory name (format depends on input, based on ISO 3166-1) (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value. Fails on invalid state/province name or code

Example

SQLCLR:

SELECT [dbo].[StateProvinceDynamic] ('California')

CLR Reference: State Province Dynamic

1. State Province Dynamic
1.1 CLR function
1.2 Expected input
1.3 Expected output
1.4 Error handling
1.5 Example

Download Manual