Not logged in - Login


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: SSN

{TOC}

"SSN"

CLR function

SQLCLR:

SELECT [dbo].[SSNRandom] (<@ssn, nvarchar(4000)>)

Expected input

Data: 9 digits string (can contain extra characters separators)

Expected output

Generic USA SSN (nvarchar(MAX))

Error handling

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

Example

SQLCLR:

SELECT [dbo].[SSNRandom] ('987654321')

Download a Trial