Subject | Re: [IBO] Calculated fields problem.. |
---|---|
Author | Markus Ostenried |
Post date | 2004-10-20T22:04:39Z |
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
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