hi,

you could write your SQL statement as

SELECT ID
, EMPNUM
, (FIRSTNAME || ' ' || MI || ' ' || LASTNAME) AS FULLNAME
, FIRSTNAME
, LASTNAME
, MI
, STREET1
, STREET2
, CITY
, STATE
, ZIPCODE
, HOMEPHONE
, HIREDATE
, TERMINATIONDATE
, COMMENT
FROM EMPLOYEE
ORDER BY 2

HTH,
Markus