Have I have been deluding myself for years?

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?