CLR Reference: Email Dynamic

{TOC}

"Email Dynamic"

CLR function

<.CLRSQLCLR: function:

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

Expected input

<.expecteddata: input:Valid dataemail type,value rule,(separated sample>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

<.expectedGeneric output:Email data type, rule, sample>(nvarchar(MAX))

Error handling

<.errorReturns handling>an empty string when passing empty or NULL value. Fails on invalid state/province name or code

Example

<.example>SQLCLR:

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