![ROWID function [Miscellaneous]](arrow-left.gif){kind=icon}
![SECOND function [Date and time]](arrow-right.gif){kind=icon}
Returns a string with trailing blanks removed.
RTRIM ( string-expression )
string-expression The string to be trimmed.
The
result data type of an RTRIM function 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.
See “REPLACE function [String]” for more information.
The following statement returns the string “Test Message” with all trailing blanks removed.
SELECT RTRIM( 'Test Message ' ) FROM iq_dummy
