The SPACE function creates a character string of a specified number
of blank spaces. The maximum length of the returned string value can be 32,739 blank
characters.
The function has this syntax:
SPACE Function
Element
Description
Restrictions
Syntax
expression
Expression that evaluates to a non-negative whole number < 256
Must be an expression, constant, column, or host variable of a built-in
integer type, or one that can be converted to an integer