Difference between revisions of "RTRIM()"

Revision as of 07:45, 8 December 2012

Purpose

Function to remove trailing blanks

Syntax

RTRIM(<expC>)

See Also

ALLTRIM(), LEFT(), LPAD(), LTRIM(), PADC(), PADL(), PADR(), RIGHT(), RPAD(), SET STRESCAPE, STRTRAN(), TRIM()

Description

The RTRIM() function is synonymous with the TRIM() function. This function removes trailing blank characters from the character expression <expC>. This function should be used in conjunction with the RPAD() function when used in index expressions.

Example

fname = "Christopher         "
sname = "Thompson    "
? len(fname)
        20
? len(rtrim(fname))
        11
? rtrim(fname) + " " + rtrim(sname)
Christopher Thompson

Products

Lianja, Lianja Server