Neoview SQL Reference Manual (R2.4)

SPACE Function
The SPACE function returns a character string consisting of a specified number of spaces, each
of which is 0x20 or 0x0020, depending on the chosen character set.
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 32768 for the ISO8859-1 character set or 16384 for the UCS2 character set.
char-set-name
can be ISO88591 or UCS2. SJIS and UTF8 are not supported. If you do not specify this second
argument, the default is the default character set for your system configuration.
The returned character string will be of data type VARCHAR associated with the character
set specified by char-set-name.
Example of SPACE
Return three spaces:
SPACE (3)
450 SQL Functions and Expressions