>I am afraid I will have to modify the table several times, and so I will have to do with code.
>
> Is there an alternative, instead of select* command, to do this task by skipping memo fields ?
You can use the COPY TO ... STRUCTURE EXTENDED command to get a table that contains a list of fields of the table you're COPYing. From that, you can tell which are Memo, General etc. and build a list of only the field types you need.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
