SQL Server SPACE() Function

Return a string with 10 spaces:

SELECT SPACE(10);

Definition and Usage

The SPACE() function returns a string of the specified number of space characters.

SPACE( number)

Parameter	Description
number	Required. The number of spaces to be returned

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse