I am running a very simple Update statement to change a key name and it
works fine on SQL Server.  When I run the exact same statement against
Paradox tables (for remote users), all Memo data disappears and cannot be
recovered.  This is not a good situation.  Is this a known bug with paradox
or the BDE?  Any ideas or suggestions?

The statement is as follows:

        update tblName
        set
        FIELD_NAME = 'NEW_DATA'
        where FIELD_NAME = 'OLD_DATA'

I don't know why this update should not work.  I do know however, that Paradox
SQL is a subset of full SQL.  I have found many things that don't work using
Local SQL that do work on a true SQL database.

Trevor de Koekkoek