ADMIN_RTrim

 Show all Hide all

Deprecated.

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
Space

Type: Scalar function
Area of use: General use

Return value: nvarchar(max)

The trimmed string.

Parameters:

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