SPACE (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
Returns a string of repeated spaces.
Transact-SQL syntax conventions
Syntax
SPACE ( integer_expression )
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
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)
Return Types
varchar
Remarks
To include spaces in Unicode data, or to return more than 8000 character spaces, use REPLICATE instead of SPACE.
Examples
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 AdventureWorks2022
.
USE AdventureWorks2022;
GO
SELECT RTRIM(LastName) + ',' + SPACE(2) + LTRIM(FirstName)
FROM Person.Person
ORDER BY LastName, FirstName;
GO
Examples: Azure Synapse Analytics and Analytics Platform System (PDW)
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
See Also
REPLICATE (Transact-SQL)
String Functions (Transact-SQL)
Built-in Functions (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort: Gedurende 2024 worden GitHub Issues uitgefaseerd als het feedbackmechanisme voor inhoud. Dit wordt vervangen door een nieuw feedbacksysteem. Ga voor meer informatie naar:Feedback verzenden en bekijken voor