Returns a specified number of spaces.
SPACE( integer-expression )
integer-expression The number of spaces to return.
LONG VARCHAR
If integer-expression is negative, a null string is returned.
SQL/2008 Vendor extension.
The following statement returns a string containing 10 spaces.
SELECT SPACE( 10 );