Thanks much for your suggestion Michael, I tried it and it took it but I can't export the report back to a file, which is my main purpose.


>For BLOBs, try the Image datatype.
>
>-Mike
>
>>I used to store reports in memo fields in VFP, now I want to do the
>>same thing in SQL 7.0, the choices that I have in SQL for the memo fields
>>are text fields, binary and varbinary, none of them seems to work for this purpose. Text stores it as plain text, binary and var binary has limitation on the file size, only support 8K, no only that when I restore the file from the
>>memo using COPY MEMO the "FRT" file gets corrupted. Is there any workaround to this.
>> =MESSAGEBOX("Thanks in advance")