Products Downloads


French version


 

 

Mobile DBMS version: this function is not permitted with DB2.

 

Syntax

RTRIM(Argument)

 

Description

The RTRIM SQL scalar function removes blanks or hexadecimal zeroes from the end of a string argument.

 

The argument must be a string.

 

The length attribute of the result is the same as the length attribute of Argument. The actual length of the result is the length of the argument minus the number of bytes removed.

If all characters are removed, the result is an empty string.

 

If the first argument can be null, the result can be null; if the first argument is null, the result is the null value.

 

Example

Assume the column HELLO of type CHAR(9) has a value of 'Hello '.

 

RTRIM(HELLO)

 

Results in: 'Hello'.

 

List of SQL scalar functions by topic

 

↑ Top of page


  • Aucune étiquette