Difference between revisions of "ALLTRIM()"

Revision as of 05:04, 25 October 2011

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