Type:
Table-valued function
This function can be used to check whether a given email address, or a separated list of email addresses, is formally valid for the given type.
If no separation should be done (i.e. when supplying only a single address) set the @Separator parameter to null.
Parameters
@Txt
mandatory
nvarchar(max)
Either a single email address or a separated list of email addresses.
@Separator
mandatory
varchar(300)
The separator between email addresses.
@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 "@". |
Resultsets
Resultset: @ReturnTable
Every element in the separated list is individually validated and returned on its own row in the return table.
Table count:
repeated exactly once
Row count:
zero or more rows
Columns
Id mandatory int
An ID representing the position of the parsed email address in the separated list.
EmailAddress mandatory string
The email address parsed from the separated list.
IsValid mandatory bit
Whether or not the email is valid.