CLR Reference: Email Dynamic

{TOC}

"Email Dynamic"

CLR function

SQLCLR:

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

Expected input

data: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. Fails on invalid state/province name or code

Example

SQLCLR:

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