>>>>SELECT * except somefield from . ... >>>>>>>>I have a large table with many fields and want to retrieve all but one field.
Select * from ... into cursor tmp ... nofilter readwrite >>>alter table ... drop column somefield >>>>>>Don't remember the exact syntax for the drop. If you want to avoid getting the field even temporarily (because it's too long, or because it's a memo), then you need a full select statement. You may use Frank's macro, or build a field list as a string with that one field omitted, then use such a field list in a script that you'll execscript(), or run as a macro.
select * from tip into cursor temp readwrite alter table temp add column sc20 c(10)