Difference between revisions of "RTRIM()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 15: Line 15:
  
 
==See Also==
 
==See Also==
[[TRIM()]], [[LTRIM()]], [[ALTRIM()]], [[STRTRAN()]]
+
[[TRIM()]], [[LTRIM()]], [[ALLTRIM()]], [[STRTRAN()]]
  
  

Revision as of 16:22, 20 March 2009

RTRIM()

Class

String Data


Purpose

Function to remove trailing blanks


Syntax

RTRIM(<expC>)


See Also

TRIM(), LTRIM(), ALLTRIM(), STRTRAN()


Description

The RTRIM() function is synonymous with the TRIM() function. This function removes trailing blank characters from the character expression <expC>. This function should be used in conjunction with the RPAD() function when used in index expressions.


Example

fname = "Christopher         "
sname = "Thompson    "
? len(fname)
        20
? len(rtrim(fname))
        11
? rtrim(fname) + " " + rtrim(sname)
Christopher Thompson


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer