Removes any trailing spaces from a string.

Syntax

---

RTRIM(<StringExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

Same as input

Usage

---

The RTRIM function removes any trailing spaces from a string.

Examples

---

SELECT RTRIM(Name) AS Name
AS Customers

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: