RTRIM function [String]

Function

Returns a string with trailing blanks removed.

Syntax

RTRIM ( string-expression )

Parameters

string-expression The string to be trimmed.

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/92 Vendor extension.

Sybase Compatible with Adaptive Server Enterprise.

See also

“LTRIM function [String]”