2 ways to half-work around that are:

in case of type()="C", as Export won't include M data
select field1, field2, cast(FieldThatWillBeDropped as M) from MyTable into cursor cTemp

or setting up a fieldlist to export, and there going by naming convention as to not always code
select field1, field2, _FieldThatWillBeDropped from MyTable into cursor cTemp
and setting up a Fieldlist following the naming convention, with my shorthand being "_" to generically divide the fields.

not ideal, but workable and faster if you have cursors large enough to make rearranging painful in waiting time.

HTH

thomas

>In this situation it hurts ;-)
>
>The thing is that the resulting cursor is exported to an excel file.
>
>>It's a cursor, just leave the extra column as is, it doesn't hurt.
>>
>>>I created a cursor. I did some additional processing after that cursor was created. Now there's a column I don't need anymore.
>>>
>>>How do I get rid of that column?
>>>
>>> I tried the following
>>>
>>>ALTER table NameOfCursor drop column NameOfColumn
>>>
>>>Didn't work.
>>>Error 1115 : Invalid operation for the cursor.
>>>
>>>Is the only solution creating another cursor and selecting only the needed columns from the original cursor?