SPACE (Transact-SQL)

SPACE (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns a string of repeated spaces.

Topic link icon Transact-SQL Syntax Conventions

  
SPACE ( integer_expression )  

-- Azure SQL Data Warehouse and Parallel Data Warehouse  
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)

varchar

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  

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

-- Uses AdventureWorks  
  
SELECT RTRIM(LastName) + ',' + SPACE(2) +  LTRIM(FirstName)  
FROM dbo.DimCustomer  
ORDER BY LastName, FirstName;  
GO  

REPLICATE (Transact-SQL)
String Functions (Transact-SQL)
Built-in Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft