Difference between revisions of "PADR()"

Revision as of 05:44, 8 December 2012

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

Lianja Server, Lianja