Repeating a Blank Space N Times : SPACE « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. SPACE
3>
4> SELECT 'Give me some' + SPACE(6) + 'space.'
5> GO

------------------------
Give me some      space.

(1 rows affected)
1>








12.19.SPACE
12.19.1.SPACE returns a set number of spaces.
12.19.2.Repeating a Blank Space N Times