TRIM()

From Lianjapedia
Revision as of 12:37, 8 December 2009 by Helengeorge (Talk)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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, Recital Server