>>Yes, NULL can't be compared. NULL is just "Don't know" If you want to compare NULLs use NVL() function:
>>
>>? NVL(oLeft.FieldWithNull,0) == NVL(oRight.FieldWithNull,0)
>>? NVL(oLeft.FieldWithNull,[]) == NVL(oRight.FieldWithNull,[])
>>? NVL(oLeft.FieldWithNull,{}) == NVL(oRight.FieldWithNull,{})
>>
>
>No I don't want to compare each field seperately, but now I understand why the my comparison results in null. Thanks.
As I said, this of NULLs as VFP (or any other language) way to say to you "I don't know". You can't compare this. The result always will be "I don't know":
"I don't know" == 1 -> I don't know :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.