Not logged in - Login / Register


View History

CLR Reference: Email Dynamic

"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)