CLR Reference: SIN

{TOC}

"SSN Dynamic "

CLR function

SQLCLR:

SELECT [dbo].[SSNDynamic][dbo].[SINRandom] (<@ssn,(<@sin, nvarchar(4000)>)

Expected input

Data: 9Valid digitsSocial stringInsurance Number (can contain extra characters separators)

Expected output

Generic USA SSNSIN (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value. Fails on invalid SSNSIN format

Example

SQLCLR:

SELECT [dbo].[SSNDynamic][dbo].[SINRandom] ('123456789')('987 654 321')