>Tore,
>
>>>Does your explanation mean that BINARY indexed fields can't participate in WHERE X = Y type SQL join conditions, only WHERE X conditions?
>>
>>Yes, that's correct.
>
>Thanks for your help and patience. I understand BINARY indexes now.
>
>Malcolm

Verify it here

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