• NOT IN should return FALSE if any member of the set is NULL. When evaluating the IN condition, the OpenAccess SDK SQL engine treats comparison of any value with NULL as FALSE, so NOT IN will become TRUE.
SELECT * FROM emp WHERE job NOT IN
(SELECT job FROM emp WHERE job IS NULL)
This example should return no results if there is an emp record with NULL value for Job.
• Embedded nulls in fields that are of the CHAR data type are not supported.
