SQL SPACE() function is used to return space characters, the number of the characters is indicated by the interger parameter. It is supported by MySQL and MS SQL Server, but not Oracle.
SQL SPACE Function Syntax
SPACE(int)
int: the number of the spaces.
SQL SPACE Function Example
SELECT SPACE(9) -- Will return 9 space characters.
SELECT 'Hello' + SPACE(3) + 'World!' -- Will return 'Hello World!' -- 'Hello', then 3 spaces, then 'World!'
SELECT 'Hello' + SPACE(0) + 'World!' -- Will return 'HelloWorld!' -- 'Hello', no space, then 'World!'