Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 SPACE (Transact-SQL)
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (November 2009)
SPACE (Transact-SQL)

Returns a string of repeated spaces.

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)

char

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 Contact table in AdventureWorks.

USE AdventureWorks;
GO
SELECT RTRIM(LastName) + ',' + SPACE(2) +  LTRIM(FirstName)
FROM Person.Contact
ORDER BY LastName, FirstName;
GO
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2010 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker