Generate a string consisting of 10 spaces.
SELECT SPACE(10); |
The SPACE() function generates a string composed of a specified number of space characters.
SPACE(number) |
Parameter |
Description |
number |
Required: Specifies the number of space characters to include in the returned string. |
Works in: |
SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse |