I don't have the exact code with me now, but what I can recall is the following:

select tblLeft
scatter name oLeft

select tblRight 
scatter name oRight

? compobj(oLeft,oRight) && gives .F.

I noticed that if I compared the fields with null directly it would give .null., so

? oLeft.FieldWithNull = oRight.FieldWithNull

would result in null instead of .T.


>>Hi all,
>>
>>I am using a scatter name oFields and compobj to compare the tables, but I get a .F. if the fields contain .null. while they are identical. Can I resolve this?
>>
>>Thanks beforehand
>
>I just tried a simple test and got .t. for two records containing NULL. Can you show the code which is failing?