Difference between revisions of "RTRIM()"

Revision as of 05:56, 25 October 2011

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

Recital, Recital Server