> Rather than allowing the NOT IN syntax and risking this type of "surprise" result, FoxPro does not support the NOT IN syntax against a table which supports NULLs.

I just tested this and didn't have problem writing a NOT IN query where the table supports nulls. I even based my comparison on the nullable field and made sure there was a null value.

Tamar