>Hi All:
>
>How can I COPY to another table, FOO, but handle the memo fields in the following possible ways:
>
>1. Exclude any memo fields

COPY TO Foo FIELDS EXCLUDE MemoFieldName

>2. Convert the memo fields to character fields in the output table and just copy the first 255 characters

SELECT FieldListWithoutMemo, CAST(MemoFIeld AS C(255)) AS MemoFieldName INTO CURSOR crsTest
COPY TO Foo

>
>I realize I can do this with some programming, but is there a simpler way?
>
>Why do I want to do this?
>
>Because I want to COPY to a text file for a user and also provide the user with the structure of FOO that matches the text file. I've discovered that VFP ignores memo fields when COPYing to a text file.
>
>Thanks,
>
>Yossi