SPACE

Syntax

SPACE(N)

Purpose

SPACE() returns a string with N space characters.

Examples

Execute the following statement to return a string with five spaces:

obclient> SELECT SPACE(5);
+----------+
| SPACE(5) |
+----------+
|          |
+----------+
1 row in set