>>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.