Show all Hide all

This function takes a string and converts all characters with accents to the corresponding character without accent (i.e. 'é' will be converted to 'e', 'ö' will be converted to 'o' etc.).

It is also possible to supply a string of characters that should be excluded from being stripped of their accents.

Type: Scalar function
Area of use: General use

Return value: nvarchar(max)

The original string stipped of accents.


@String mandatory nvarchar(max)
The string to be stripped.
@CharactersToExclude mandatory nvarchar(300)
String of characters that should be excluded from having their accents stripped. The comparison with this string is case insensitive.