ALLTRIM()

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to remove leading and trailing spaces


Syntax

ALLTRIM(<expC>)]]


Description

The ALLTRIM() function trims leading and trailing spaces from the character expression <expC>. This function should be used in conjunction with the RPAD() function when used in index expressions.


See Also

LPAD(), LTRIM(), RPAD(), RTRIM(), SET STRESCAPE, STRTRAN(), TRIM()


Example

name="   Peter   "
? len(name)
        15
? name
   Peter
? alltrim(name)
Peter
? len(alltrim(name))
         5


Products

Recital Server, Recital