Question

How can the FIRSTNAME and the LASTNAME from the EMP table be concatenated to generate complete names?

Answer 1

Below is the statement that can be used to concatenate the first and last names to display full names:

FIRSTNAME II ** II LASTNAME FROM EMP