>What is a recommended method of comparing to NULL? I need to determine if a value of a field has changed. But when it changes to NULL value (and it is allow for this field) the comparison to NULL is NULL. Any suggestions on how to deal with this?
>
>Thank you.

IF ISNULL(YourField)