SPACE is a string manipulation function that manipulates all data types (BIT, BLOB, and CHARACTER), and creates a string consisting of a defined number of blank spaces.
SPACE returns a character string consisting of the number of blank spaces given by NumericExpression. The parameter must be of type INTEGER; the result is of type CHARACTER.
If the parameter is negative or zero, a zero length character string is returned. If the parameter is NULL, the result is NULL.
The string is limited to 32*1024*1024 to protect the broker from erroneous programs. If this limit is exceeded, an exception condition is issued.
Related concepts
ESQL
Related tasks
Developing ESQL
Related reference
Syntax preference
ESQL string manipulation functions
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak05251_ |