rtrim

Trims the specified expression of trailing blanks.

Syntax

rtrim(char_expr | uchar_expr)

Parameters

char_expr – is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.
uchar_expr – is a character-type column name, variable, or constant expression of unichar or univarchar type.

Examples

Example 1 – Trims the trailing blanks off after "abcd":
```
select rtrim("abcd    ")
```
```
--------
abcd
```

Usage

For Unicode, a blank is defined as the Unicode value U+0020.
If char_expr or uchar_expr is NULL, returns NULL.
Only values equivalent to the space character in the current character set are removed.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute rtrim.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com