Difference between revisions of "RTRIM()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to remove trailing blanks | Function to remove trailing blanks | ||
| − | |||
==Syntax== | ==Syntax== | ||
RTRIM(<expC>) | RTRIM(<expC>) | ||
| − | |||
==See Also== | ==See Also== | ||
[[ALLTRIM()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[PADC()]], [[PADL()]], [[PADR()]], [[RIGHT()]], [[RPAD()]], [[SET STRESCAPE]], [[STRTRAN()]], [[TRIM()]] | [[ALLTRIM()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[PADC()]], [[PADL()]], [[PADR()]], [[RIGHT()]], [[RPAD()]], [[SET STRESCAPE]], [[STRTRAN()]], [[TRIM()]] | ||
| − | |||
==Description== | ==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. | 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== | ==Example== | ||
| Line 26: | Line 22: | ||
Christopher Thompson | Christopher Thompson | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 10:27, 12 December 2012
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
Lianja, Lianja Server
