RTRIM function [String]

Removes leading and trailing blanks from a string.

Syntax 
RTRIM( string-expression )
Parameters

  • string-expression   The string to be trimmed.

Returns

VARCHAR

NVARCHAR

LONG VARCHAR

LONG NVARCHAR

Remarks

The actual length of the result is the length of the expression minus the number of characters removed. If all the characters are removed, the result is an empty string.

If the argument is null, the result is the null value.

See also
Standards and compatibility

  • SQL/2003   Vendor extension.

    The TRIM specifications defined by the SQL/2003 standard (LEADING and TRAILING) are supplied by the SQL Anywhere LTRIM and RTRIM functions respectively.

Example

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

SELECT RTRIM( 'Test Message     ' );
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1