>? NVL(oLeft.FieldWithNull,0) == NVL(oRight.FieldWithNull,0) && If FieldWithNull is some of the numeric fields >? NVL(oLeft.FieldWithNull,[]) == NVL(oRight.FieldWithNull,[]) && If FieldWithNull is char >? NVL(oLeft.FieldWithNull,{}) == NVL(oRight.FieldWithNull,{}) && If FieldWithNull is date >No I don't want to compare each field seperately, but now I understand why the my comparison results in null. Thanks.