SPACE (SQL Server Compact Edition)
Returns a string of repeated spaces.
Syntax
SPACE ( integer_expression )
Arguments
- 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.
Return Value
nvarchar
Example
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