Firstly dont use a * in your select  statment, this is very bad practice for
several reasons, but to do what you want do...

select FName + ' ' + LName as fullname from library_Author

(Along with any other columns that you require)