How to put a space between two SQL columns after joining them?

Question

I have joined two columns, first name\last name into one and named it with an alias which is all good. But how do I put a space between first and last name?

au.first_name || au.last_name Name

Answer 1

here:

au.first_name || ' ' || au.last_name Name

Answer 2

You can add the space in the same manner that you have concatenated the first and last names,

au.first_name ||' ' || au_last_name name