clear ON ERROR CREATE CURSOR testBinary (aa i NOT NULL) INDEX ON EMPTY(aa) TAG bitmap BINARY SYS(3054,12) SELECT * FROM testBinary t1 WHERE EMPTY(aa) INTO ARRAY ZZ ? SELECT * FROM testBinary t1 HAVING EMPTY(aa) INTO ARRAY ZZ ? SELECT * FROM testBinary t1 JOIN testBinary t2 ON EMPTY(t1.aa) AND EMPTY(t2.aa) INTO ARRAY ZZ ? SELECT * FROM testBinary t1 FULL JOIN testBinary t2 ON EMPTY(t1.aa) AND EMPTY(t2.aa) INTO ARRAY ZZ