>Does any one have any suggestions on what software to use in the following scenario.
>I have a SQL database, that has a memo field that needs to be compressed. The field need to be compressed using VFP 6.0.
>Thank You

You could write text to a file, compress it with some compression program (using command-line options), and then save the resulting record to the memo field. Instead of a program like WinZIP that uses command-line parameters, some DLLs are available as well. I suggest you search the download section.

Then, to retrieve the data, you will need to proceed in reverse order.

I don't know whether it is worth the trouble (except perhaps in some exceptional cases), because of the additional overhead for saving and retrieving. SQL Server can handle large amounts of data, and it should be possible to get hard disks that are big enough, without using compression. Do some calculations, how big your data will be with, and without, compression - perhaps you can reduce the size by a factor of 2 or 3 if you use compression on texts.