В 9 фоксе такая у меня непонятка:
insert into n_960_;
SELECT SPACE(5) AS vservtype,;
PADR(ALLTRIM("960"),5," ") AS vcode,;
MIN(Spisnap.datbeg) AS ddate,;
PADR(STR(Spabon.uid,10),10,' ') AS vsacct,;
SPACE(30) AS vtechcode, ;
SPACE(10) AS vtechtype,;
PADR("43",10," ") AS vzone,;
PADR("11",5," ") AS vsubstype,;
PADR(ALLTRIM(Spabon.namabn),30," ") AS vsurname,;
SPACE(100) AS vname,;
SPACE(30) AS vpatr,;
PADR(ALLTRIM(STR(Sprul.kodadm+430000))+PADL(ALLTRIM(STR(Sprul.kodul)),4,'0'),30,' ') AS vstreet,;
PADR(Spabon.domkv,5," ") AS vhouse,;
SPACE(5) AS vletter,;
SPACE(5) AS vflat,;
IIF(EMPTY(Splgot.datend),PADL(Splgot.vprivtype,10," "),SPACE(10)) AS vprivtype,;
SPACE(5) AS vwservt,;
IIF(EMPTY(Splgot.datend),PADL(Splgot.vprevservt,10," "),SPACE(10)) AS vprevservt,;
SPACE(5) AS vwservtcon,;
{} AS dpaym,;
0000000000.00 AS nsumone,;
SPACE(30) AS vadddata,;
IIF(AT("???????",Spabon.namabn)>0,"1","0") AS vsecret,;
SPACE(5) AS voper,;
{} AS dwrite,;
SPACE(10) AS vmfo,;
SPACE(20) AS vbankacct,;
SPACE(10) AS vokpo,;
PADR(Spabon.ind_nom,10," ") AS vtaxcode,;
PADR(Spabon.nom_svid,10," ") AS vcoderegnd,;
SPACE(10) AS vpostdept,;
SPACE(10) AS vatc,;
0000000000.0000 AS ncpct,;
0000000000 AS norder,;
SPACE(5) AS vdistr,;
{} AS dend,;
SPACE(10) as VSTREETK,;
SPACE(5) as VHOUSEK,;
SPACE(5) as VFLATK;
FROM ;
spabon ;
INNER JOIN spradm ;
ON Spabon.kodadm = Spradm.kodadm ;
INNER JOIN spisnap ;
ON Spabon.schet = Spisnap.schet ;
INNER JOIN sprlg ;
ON Splgot.kodlg = Sprlg.kodlg ;
LEFT OUTER JOIN splgot ;
ON Spabon.schet = Splgot.schet ;
INNER JOIN sprul ;
ON Sprul.kodadm = Spabon.kodadm;
AND Sprul.kodul = Spabon.kodul;
WHERE Spabon.kodvabn = ( 1 );
AND ( Spabon.schet BETWEEN 200000 AND 700000;
OR Spabon.schet > ( 800000 ) );
GROUP BY 1, 2, Spabon.UID, 5, 6, 7, 8, Spabon.namabn, 10,;
11, 12, Spabon.domkv, 14, 15, 16, Splgot.vprevservt, 18, 19, 20, 22,;
23, 24, 25, 26, 27, Spabon.ind_nom, Spabon.nom_svid, Spabon.nom_svid, 31, 32, 33, 34, 35;
ORDER BY Spabon.UID

В полученой таблице некоторые поля имеют тип Varchar которые после команды
copy to .... as 866 type fox2x
стают memo-полями.
как обойти?

Я так и знал, что ответ будет от ВладимирМ.
БОЛЬШОЕ СПАСИБО!

Но не понятно по какому признаку он ставит Varchar или Character.
Что занятно таблица, в котрую инсертится не имеет полей типа Varchar.
Или Insert into - SQL тоже переписывает табл. как и простой Select into table ?

Пока писал "СПАСИБО" ВладимируМ, пришёл ещё ответ.
А ещё одно персональное спасибо FM32YO aka KID!!!