Another question:

The syntax

COPY TO Foo FIELDS EXCLUDE MemoFieldName

doesn't seem to be documented in the help file.

>>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