Export (0) Print
Expand All

SPACE (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns a string of repeated spaces.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database, Azure SQL Data Warehouse Public Preview.

Topic link icon Transact-SQL Syntax Conventions


SPACE ( integer_expression )

integer_expression

Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned.

For more information, see Expressions (Transact-SQL)

To include spaces in Unicode data, or to return more than 8000 character spaces, use REPLICATE instead of SPACE.

The following example trims the last names and concatenates a comma, two spaces, and the first names of people listed in the Person table in AdventureWorks2012.

USE AdventureWorks2012;
GO
SELECT RTRIM(LastName) + ',' + SPACE(2) +  LTRIM(FirstName)
FROM Person.Person
ORDER BY LastName, FirstName;
GO
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft