Using SPACE with SELECT statement

SELECT au_fname + SPACE(1) + au_lname AS au_fullname FROM authors

This will seperate the last name and first name by a single space.To give 3 spaces we could write it as follows.

SELECT au_fname + SPACE(3) + au_lname AS au_fullname FROM author