Do Concatenation like below
select First Name + ' ' + Last Name AS Full_Name from FriendsAccount
Always put the columns(which has space in name) inside square brackets. Better avoid spaces in column names.
select [First Name] + ' ' + [Last Name] AS Full_Name from FriendsAccount