Neoview SQL Reference Manual (R2.2)

SPACE Function
The SPACE function returns a character string consisting of a specified number of spaces.
SPACE is a Neoview SQL extension.
SPACE (length [,char-set-name])
length
specifies the number of characters to be returned. The number count must be a value greater
than or equal to zero of exact numeric data type and with a scale of zero. length cannot
exceed 4096.
char-set-name
can be ISO88591 or UCS2. The default is ISO88591.
The returned character string will be of data type VARCHAR associated with the character
set specified by char-set-name.
Example of SPACE
Return 3 spaces:
SPACE (3)
SPACE Function 407