Difference between revisions of "TRIM()"

Latest revision as of 16:37, 8 December 2009

Purpose

Function to remove trailing blanks

Syntax

TRIM(<expC>)

See Also

ALLTRIM(), LTRIM(), RTRIM()

Description

The TRIM() function is synonymous with the RTRIM() function. It removes trailing blank characters from the character expression <expC>. This function should only be used in conjunction with the RPAD() function when used in index expressions, since index keys must be fixed length.

Example

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

Products

Recital, Recital Server