SPACE returns a set number of spaces. : SPACE « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. SPACE
3> SELECT "java2s"+SPACE(10)+"java2s"
4> GO

----------------------
java2s          java2s

(1 rows affected)








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