Difference between revisions of "PADC()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 21: | Line 21: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Latest revision as of 06:41, 4 February 2013
Purpose
Function to pad out a string to a specified length
Syntax
PADC(<expC1>, <expN> [, <expC2>])
See Also
CENTER(), LPAD(), PADL(), PADR(), RPAD(), SET STRESCAPE, STR(), STREXTRACT(), STRTRAN(), STRZERO(), STUFF(), SUBSTR(),
Description
The PADC() function centers a character string <expC1> and pads out the right and left of the string, to a total length of <expN> characters with blanks. The optional <expC2> may be used to pad <expC1> with a character string instead of blank spaces. PADC() returns the new string. If the string being processed is longer than the specified total length, it is returned unchanged.
Example
? ["] + padc("abc",7) + ["] " abc "
Products
Lianja, Lianja Server