SQL Server/T-SQL Tutorial/String Functions/SPACE

Repeating a Blank Space N Times

3>
4> SELECT "Give me some" + SPACE(6) + "space."
5> GO
------------------------
Give me some      space.
(1 rows affected)
1>

SPACE returns a set number of spaces.

3> SELECT "sqle"+SPACE(10)+"sqle"
4> GO
----------------------
sqle          sqle
(1 rows affected)