>I feel really stupid asking this question as I figured this out two years ago and can't remember how I did it. Need to append the contents of a character field into an existing memo field for each record in the table ( getting rid of a field that is rarely used ). Am using a COPY TO a text file for the character field and then an APPEND MEMO from the text file. However, this gives me " "s around the info. How can I get rid of them? It sure seems like I went about this a different way.

Will something like this work for you?

REPLACE ALL mymemofield WITH mymemofield + mytextfield