TRIM()

From Recital Documentation Wiki
Revision as of 16:48, 28 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search


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 Database Server, Recital Mirage Server, Recital Terminal Developer