>>>Have I have been deluding myself for years?
>>>
>>
>>Apparently. < g >
>>
>>>If I APPEND FROM from a table which has a memo field named MyNotes into a table with a character field named MyNotes, ought not the contents of MyNotes be transferred from the memo field into the character field, or at least as much as will fit?
>>
>>APPEND FROM/COPY TO don't process memo fields. Never have.
>>
>>Tamar
>
>Another interesting result is that ALTER TABLE ALTER COLUMN will retain the contents of a character field when it's converted to a memo, but not the other way.
>
>Cheers,
>
>Andrew

That's right, I've rarely if ever converted a memo field to a character field, but often the other way. I guess that's why I thought it would work. Modify structure doesn't work either.

Getting close to 'hanging up the spurs' I reckon.

Thanks for clarification.