<< INSERT INTO FAO_PERSONNEL
(EMPNO,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,DOH)
SELECT EMPNO,FIRSTNAME,MI,LASTNAME,DOB,DOH FROM EMPINFO WHERE EMPNO = 577

should work.>>

Uh-Yep. I thought it was probably something staring me in the face like an
overwrought kid demanding his belated allowance.

Thanks Magnus, P.I.!

Clay Shannon,
Dimension 4 Software