RTRIM()

From Recital Documentation Wiki
Revision as of 11:49, 21 July 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Purpose

Function to remove trailing blanks


Syntax

RTRIM(<expC>)


See Also

ALLTRIM(), LEFT(), LPAD(), LTRIM(), RIGHT(), RPAD(), SET STRESCAPE, 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