In addition, if you compress data it'll not be a text anymore. You may want to change the type of column in the SQL Serve table to binary to avoid code page translations.

>
>My app is VFP9 on MSSQL database.
>
>I store contents of text files in memo field of a table using APPEND MEMO myfield FROM txtfile OVERWRITE
>
>I need to find out how I can compress a text file so I can store the compressed file into the memo field so that I can improve my app performance when I retrieve data from the table containing the memo field.
>