Difference between revisions of "RTRIM()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 8: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ALLTRIM()]], [[LTRIM()]], [[STRTRAN()]], [[TRIM()]] | + | [[ALLTRIM()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[PADC()]], [[PADL()]], [[PADR()]], [[RIGHT()]], [[RPAD()]], [[SET STRESCAPE]], [[STRTRAN()]], [[TRIM()]] |
Latest revision as of 11:50, 21 July 2010
Purpose
Function to remove trailing blanks
Syntax
RTRIM(<expC>)
See Also
ALLTRIM(), LEFT(), LPAD(), LTRIM(), PADC(), PADL(), PADR(), RIGHT(), RPAD(), SET STRESCAPE, STRTRAN(), TRIM()
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, Recital Server
