Hi Ray,

Am I missing the point (?) but why don't you use your original code but make the first query select into a TABLE in what ever directory/network pc that you want ? ie:-

select 'MAIL',fm_addr1,fm_addr2,fm_city,fm_state,fm_zip;
from family;
where family_id=fid;
into table x1

select 'SITE',fp_addr1,fp_addr2,fp_city,fp_state,fp_zip;
from family;
where family_id=fid;
into cursor x2

select x1
append from x2