UFN_EMAILRECIPIENTHASOPTEDOUT
Returns weather an anonymous user has opted out of communications
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILADDRESS | nvarchar(255) | IN |
Definition
Copy
create function dbo.UFN_EMAILRECIPIENTHASOPTEDOUT
(
@EMAILADDRESS nvarchar(255)
)
returns bit
with execute as caller
as BEGIN
if exists (select 1 from EmailList_GlobalSubscription where EmailAddress=@EMAILADDRESS and HasOpted=0)
return 1;
return 0;
END