ALLTRIM()

From Lianjapedia
Revision as of 05:23, 4 February 2013 by Helen.george (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

Lianja Server, Lianja