Difference between revisions of "RTRIM()"

Latest revision as of 06:44, 4 February 2013

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