Difference between revisions of "ALLTRIM()"

Revision as of 12:25, 7 December 2012

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

Lianja Server, Lianja