If FNAME is CHAR(6) with a value of BEN, and LNAME is CHAR(8)
with a value of JOHNSON, FNAME CONCAT LNAME results in BEN JOHNSON with a length of 14. (There are three blank spaces between
the first and the last names.)
This query lists all last names in Q.INTERVIEW that begin with
letters greater than M, and combines those last names with their
respective first names.
SELECT LASTNAME CONCAT ', ' CONCAT FIRSTNAME
FROM Q.INTERVIEW
WHERE LASTNAME > 'M'