Add Space between 2 or more String or Column in SQL

Below query will result to add space between first name and last name using space function
 
 
Output will be