CLR Reference: SIN
-
Request
a trial -
Request
a demo -
Request
a quote
CLR Data Masking Components
Open Navigation Article
CLR Reference: SIN
-
Request
a trial -
Request
a demo -
Request
a quote
SIN
CLR function
SQLCLR:
SELECT [dbo].[SINRandom] (<@sin, nvarchar(4000)>)
Expected input
Data: Valid Social Insurance Number (can contain extra characters separators)
Expected output
Generic USA SIN (nvarchar(MAX))
Error handling
Returns an empty string when passing empty or NULL value. Fails on invalid SIN format
Example
SQLCLR:
SELECT [dbo].[SINRandom] ('987 654 321')
×
![Enlarged Picture]()
CLR Reference: SIN
Download Manual
