BLANKS( ) function

Returns a string containing a specified number of blank spaces.

Syntax

BLANKS(count)

Parameters

Name	Type	Description
count	numeric	The number of blank spaces to insert.

Output

Character.

Examples

Basic examples

Returns "     ":

BLANKS(5)

Returns "ABC Corporation":

"ABC" + BLANKS(1) + "Corporation"

Remarks

When to use BLANKS( )

Use the BLANKS( ) function to harmonize fields, to initialize variables in scripts, or to insert blank spaces when formatting fields or concatenating strings.