SQL Server/T-SQL/String Functions/Space

SPACE(20 - LEN(Name))

create table employee(
    ID          int,
    name        nvarchar (10),
    salary      int,
    start_date  datetime,
    city        nvarchar (10),
    region      char (1))
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (1,  "Jason", 40420,  "02/01/94", "New York", "W")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (2,  "Robert",14420,  "01/02/95", "Vancouver","N")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (3,  "Celia", 24020,  "12/03/96", "Toronto",  "W")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (4,  "Linda", 40620,  "11/04/97", "New York", "N")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (5,  "David", 80026,  "10/05/98", "Vancouver","W")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (6,  "James", 70060,  "09/06/99", "Toronto",  "N")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (7,  "Alison",90620,  "08/07/00", "New York", "W")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (8,  "Chris", 26020,  "07/08/01", "Vancouver","N")
GO
insert into employee (ID, name,    salary, start_date, city,       region)
              values (9,  "Mary",  60020,  "06/09/02", "Toronto",  "W")
GO
select * from employee
GO
SELECT Name + SPACE(20 - LEN(Name)) 
FROM Employee
GO
drop table employee
GO

SPACE: returns a set number of spaces

1> -- SPACE: returns a set number of spaces.
2>
3> SELECT "Robin"+SPACE(10)+"Dewson"
4> GO
---------------------
Robin          Dewson
(1 rows affected)
1>