When I try this, I get the error: SQL column 'DOB' not found.

Here is my code:

select name,ssn,dateofbirt,unit,period,resident,batch,limit ;
as applicant,ssn,dob,harvest,phase,resident,batch,limit ;
from &_afnfile into table allgqtmp

Any ideas???

Sunshine

P.S. And thanks for your response!