RTRIM Function [String]

Returns a string with trailing blanks removed.

Syntax

RTRIM ( string-expression )

Parameters

Parameter	Description
string-expression	The string to be trimmed.

Returns

VARCHAR

NVARCHAR

LONG VARCHAR

LONG NVARCHAR

Note: The result data type is a LONG VARCHAR. If you use RTRIM in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set RTRIM to the correct data type and size.

Example

The following statement returns the string “Test Message” with all trailing blanks removed.

SELECT RTRIM( 'Test Message     ' ) FROM iq_dummy

Standards and Compatibility

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Compatible with Adaptive Server Enterprise.