Hello Jason,

Starting with versions Cx

TIBOTable.Filter :=
'DEPARTMENT WHERE COMPNO = 1 AND
DEPTNO IN (SELECT DEPTNO FROM DEPARTMENT WHERE COMPNO = 1)'

or

TIBOTable.Filter :=
'DEPARTMENT WHERE COMPNO = 1 AND
(DEPTNO IN (SELECT DEPTNO FROM DEPARTMENT WHERE COMPNO = 1))'

now fail to parse.

I may have over simplified the SQL such that the question doesn't
nake much sense anymore, but that is imaterial :)

Best Regards,
Hans