SoftadminUtil.Email_IsValidEmailAddress

Type: Scalar function

This function answers the question whether a given string is a formally valid email address.

The special case of a null-string will give a return value of 0.

The function takes one varchar parameter that is assumed to resemble a single email address. For validation of a separated list of addresses, see the table valued function ADMIN_ValidateEmailAddress.

Return value: bit

Returns 1 if the email address is formally valid and 0 otherwise.

Parameters

@EmailAddress mandatory varchar(max)
A string representing the single email address to be checked.