>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?

do case
case isnull(Temp2.media_order_detail) or isnull(m.nOrigModId)
    lRetVal = (isnull(Temp2.media_order_detail) = isnull(m.nOrigModId))

otherwise
    lRetVal = (Temp2.media_order_detail = nOrigModId)

endcase