<< Click to Display Table of Contents >> Navigation:  Available Functions > PadL()

Syntax

PadL( <FieldName>, <NumericValue> )

 

Purpose

To return the characters of a field, right-justified using a character value that is <NumericValue> characters long. The resulting character value will be lengthened by adding spaces on the left to make it <NumericValue> characters long.

 

Parameters

<FieldName> is the name of a field, or an expression of any type.

 

<NumericValue> is the total length you wish the resulting character value to be.

 

Returns

A Character value.

 

Usage

The "PadL()" function may be used to right-justify text within a field of a report like this:

 

PadL( .Last_Name., 50 )

 

If you were to enter the above "PadL()" expression for a Field Name/Expression of a report, the last names of donors would be right-justified within a report column which is fifty characters wide.