SPACE function

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.

Syntax

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