You are here: Functions > BLANKS()

BLANKS()

BLANKS() creates a character string of specified length consisting solely of blanks.

Use BLANKS() to format a field with blanks, to initialize a variable or to make a field larger by adding a fixed number of blanks.

Function Format

BLANKS(#)

BLANKS() returns a string containing a specified number of blanks. The string length # must be a numeric constant.

Examples

BLANKS(5) = " "

BLANKS(10) = " "

In the following example, blanks are added to the character string "abc":

"abc" + BLANKS(5) = "abc "