Difference between revisions of "RTRIM()"

Revision as of 16:09, 28 October 2009

Purpose

Function to remove trailing blanks

Syntax

RTRIM(<expC>)

See Also

ALLTRIM(), LTRIM(), 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 Database Server, Recital Mirage Server, Recital Terminal Developer