Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Returns a string of repeated spaces.

SPACE ( integer_expression )


A positive integer, or an expression that can be implicitly converted to int, that indicates the number of spaces. If integer_expression is negative or greater than 255, a null string is returned.


The following example concatenates the last name, a comma, five spaces, and then the first name of each employee in the Employees table.

SELECT [Last Name] + ',' + SPACE(5) + [First Name]
FROM Employees
© 2016 Microsoft