Difference between revisions of "PADR()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 27: | Line 27: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:String Data]] | [[Category:String Data]] | ||
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
Revision as of 15:27, 13 October 2009
Class
String Data
Purpose
Function to pad out a string to a specified length
Syntax
PADR(<expC1>,<expN>,<expC2>)
See Also
CENTER(), LPAD(), PADC(), PADL(), RPAD(), STR(), STRTRAN(), STRZERO(), STUFF()
Description
The PADR() function left justifies a character string <expC1> and pads out the right of the string, to a total length of <expN> characters. PADR() returns the new string. If <expC2> is not specified, <expC1> will be padded with blanks, otherwise, the string will be padded with the character specified by <expC2>. If the string being processed is longer than the specified total length, it is truncated. This function is the same as RPAD() and is included for language compatibility.
Example
? rpad("abc",6,"X") abcXXX
Products
Recital Server, Recital
