>Is it possible to use a wildcard (*) for the fields in a select statement and then EXCLUDE one of the fields? I need a SELECT-SQL that exports everything except the memo field into a cursor. For convienence sake I'd prefer to do it all in the SELECT rather than additional commands such as set fields afterwards.
>
>The table has lots of fields, so I'd also like to not have to type them all individually.
>
>Thanks

Use this handy function
Re: INSERT not as maintainable? Thread #1140411 Message #1140531