Type:
Aggregate function
This function answers the question whether a given string is a formally valid email address of the given type.
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 SoftadminUtil.Email_ValidateEmailAddressesOfType.
Return value: bit
Returns 1 if the email address is formally valid and 0 otherwise.
Parameters
@EmailAddress
mandatory
nvarchar(max)
A string representing the single email address to be checked.
@Type
mandatory
varchar(30)
The type of the email address to validate.
| Possible value | Description |
|---|---|
| International |
Will allow any character before and after the "@". Use this when the purpose of the email is storage only, as Softadmin will not be able to send emails to addresses with international domains. |
| InternationalLocalPart |
Will allow any character before the "@". Use this when the purpose of the email is storage only, as Softadmin will not be able to send emails to addresses with international characters. |
| Strict | Will only allow certain special characters, numbers, and characters from the english alphabet before the "@". |