CLR Reference: Generic Phone Nu

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: Generic Phone Nu

Request
a trial
Request
a demo
Request
a quote

API Reference

SSIS Reference

Generic Phone Nu

CLR function

SQLCLR:

SELECT [dbo].[PhoneRandom] (<@phone, nvarchar(4000)>)

Expected input

data: numeric phone (can contain separators). Length without separators from 9 to 15 digits.

Expected output

Generic Phone of the same format as input (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value. Fail on digits count less than 9 or more than 15

Example

SQLCLR:

SELECT [dbo].[PhoneRandom] ('+1.898.456.4456')

CLR Reference: Generic Phone Nu

1. Generic Phone Nu
1.1 CLR function
1.2 Expected input
1.3 Expected output
1.4 Error handling
1.5 Example

Download Manual