rtrim

Trims the specified expression of trailing blanks.

Syntax

rtrim(char_expr | uchar_expr)

Parameters

Examples

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.

Related reference
ltrim