bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server SPACE() Function

Example

SELECT SPACE(10);

Definition and Usage

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

SPACE(
number
)

Parameter Values

ParameterDescription
numberRequired. The number of spaces to be returned

Technical Details

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

Previous

SQL Server SOUNDEX() Function

Next

SQL Server STR() Function