Type: Scalar function

This function removes whitespace from the end of a string and should in most cases be used instead of the native T-SQL function RTRIM that only trims the space character.

List of characters considered whitespace:

Horizontal tab
New line
Vertical tab
Form feed
Carriage return

Return value: nvarchar(max)

The trimmed string.


@Str mandatory nvarchar(max)
The string to be trimmed.