Show all Hide all

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.

Type: Scalar function
Area of use: General use

Return value: nvarchar(max)

The stripped string.


@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.