Difference between revisions of "PADR()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
String Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to pad out a string to a specified length
 
Function to pad out a string to a specified length
Line 8: Line 4:
  
 
==Syntax==
 
==Syntax==
PADR(<expC1>,<expN>,<expC2>)
+
PADR(<expC1>, <expN> [, <expC2>])
  
  
 
==See Also==
 
==See Also==
[[CENTER()]], [[LPAD()]], [[PADC()]], [[PADL()]], [[RPAD()]], [[STR()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]]
+
[[CENTER()]], [[LPAD()]], [[PADC()]], [[PADL()]], [[RPAD()]], [[SET STRESCAPE]], [[STR()]], [[STR_PAD()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]]
  
  

Latest revision as of 15:41, 21 July 2010

Purpose

Function to pad out a string to a specified length


Syntax

PADR(<expC1>, <expN> [, <expC2>])


See Also

CENTER(), LPAD(), PADC(), PADL(), RPAD(), SET STRESCAPE, STR(), STR_PAD(), 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