SPACE
Returns a string of repeated spaces.
Syntax
SPACE ( integer_expression )
Arguments
integer_expression
Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned.
Return types
varchar or nvarchar
Examples
SELECT SPACE(2);