Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
PADL( ) | PADR( ) | PADC( ) Functions
Collapse the table of content
Expand the table of content

PADL( ) | PADR( ) | PADC( ) Functions

Returns a string from an expression, padded with spaces or characters to a specified length on the left or right sides, or both.


PADL(eExpression, nResultSize [, cPadCharacter])

PADR(eExpression, nResultSize [, cPadCharacter])

PADC(eExpression, nResultSize [, cPadCharacter])

Parameters

eExpression

Specifies the expression to be padded. This expression can be any expression type except a logical expression or a general or picture field.

nResultSize

Specifies the total number of characters in the expression after it is padded.

cPadCharacter

Specifies the value to use for padding. This value is repeated as necessary to pad the expression to the specified number of characters.

If you omit cPadCharacter, spaces (ASCII character 32) are used for padding.

Character

PADL( ) inserts padding on the left, PADR( ) inserts padding on the right, and PADC( ) inserts padding on both sides.

STORE 'TITLE' TO gcString
CLEAR
? PADL(gcString, 40, '=')
? PADR(gcString, 40, '=')
? PADC(gcString, 40, '=')

Community Additions

ADD
Show:
© 2015 Microsoft