CLR Reference: SIN DYnamic

{TOC}

"SIN"

CLR function

SQLCLR:

SELECT [dbo].[SINDynamic] (<@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].[SINDynamic] ('123-456-789')