Sergey,
If one or both are null the final result is .null. not .t. or .f.
>Your expression is correct. When both values are NULLs they neither equal nor unequal.
>
>>In this code, if either of the 2 values is null, lRetVal is set to NULL.
>>
>>
>>lRetVal = (Temp2.media_order_detail = nOrigModId)
>>
>>
>>How do I compare both values to see if they are the same?