version 11
SPACE (arithmetic_expression)
Description
The SPACE function returns a character string made up of the given number of spaces indicated in arithmetic_expression. If the value of the arithmetic_expression is less than zero, a NULL value will be returned.
Example
This example adds three spaces in front of the last names of the PEOPLE table:
SELECT CONCAT(SPACE(3),PERSONS.LastName) FROM PEOPLE;