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