SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-145
SPACE Function
SPACE Function
The SPACE function returns a character string consisting of a specified number of
spaces.
SPACE is an SQL/MX extension.
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, KANJI, KSC5601, 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.
Examples of SPACE
•
Return 3 spaces:
SPACE (3)
SPACE (length [,char-set-name])