Difference between revisions of "ALLTRIM()"

Revision as of 17:02, 26 October 2009

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(), STRTRAN(), TRIM()

Example

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

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer