Not logged in - Login


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: Email Dynamic

{TOC}

"Email Dynamic"

CLR function

SQLCLR:

SELECT [dbo].[EmailDynamic] (<@email, nvarchar(4000)>, <@preserveServer, bit>)

Expected input

Data: Valid email value (separated by @; contains only letters and digits after last dot) preserveServer/encodeServer: 0 or false to not mask domain; 1 or true to mask domain

Expected output

Generic Email (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value.

Example

SQLCLR:

SELECT [dbo].[EmailDynamic] ('virginia@mask-me.net', 1)

Download a Trial