Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Scalar function

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.

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.