Are you by any chance connecting to Oracle.
I had this problem I solved it by using a specialized function...

CSEMPTY which treats NULL's as EMPTY..

I then had to replace all EMPTY's with CSEMPTY in all places...

The problem is if you update an Oracle table to the EMPTY value it is null..
I.E. there is no EMPTY value in a table just a null. Foxpro however treats NULL's and empty's separetly.
This is probably the same for other databases...

There is no way to convert all NULL's to empty but you could do...
replace field with "" for field=NULL
for all fields in the DB..


FUNCTION CSEMPTY()
**ADDS CHeck for is null to existing code..
**Note: 0 is empty......
LPARAMETERS carg
LOCAL lreturn
lreturn=EMPTY(carg) OR ISNULL(carg)
RETURN lreturn

Hope that helps..