CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
US Phone Nu
CLR function
SQLCLR:
SELECT [dbo].[UsaPhoneRandom] (<@usaPhone, nvarchar(4000)>)
Expected input
Data: numeric USA Phone (can contain separators). Length without separators - 10 digits.
Expected output
Generic USA Phone of the same format as input (nvarchar(MAX))
Error handling
Returns an empty string when passing empty or NULL value. Fails on digits count less or more than 10
Example
SQLCLR:
SELECT [dbo].[UsaPhoneRandom] ('898.456.4456')
×
CLR Reference: US Phone Nu
CLR Reference: US Phone Nu
- 1. US Phone Nu
- 1.1 CLR function
- 1.2 Expected input
- 1.3 Expected output
- 1.4 Error handling
- 1.5 Example
CLR Data Masking Components
CLR Reference