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