Type:
Scalar function
This function takes a string and strips away (removes) all characters that are not part of the latin alphabet (i.e. the letters A-Z) and that are not digits.
If the string contains no alphanumeric characters at all then a value of null is returned.
It is also possible to supply a string of characters that should be excluded from being stripped.
Return value: nvarchar(max)
The stripped string.
Parameters
@String
mandatory
nvarchar(max)
The string to be stripped.
@AdditionalCharactersAllowed
mandatory
nvarchar(300)
String of additional characters that should be allowed and these will thus not be stripped. The comparison with this string is case insensitive.