Difference between revisions of "TRIM()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to remove trailing blanks
 
Function to remove trailing blanks

Revision as of 16:49, 28 October 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 Database Server, Recital Mirage Server, Recital Terminal Developer