RTRIM()

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, Recital Server