Export (0) Print
Expand All
Expand Minimize

SPACE (SQL Server Compact Edition)

Returns a string of repeated spaces.


SPACE ( integer_expression )

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.

nvarchar

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

SELECT LastName + ',' + SPACE(2) + FirstName
FROM Employees
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft