using SQL IN Statement with stringfields does not work in combination with any other selection argument

[praaphorst]

select * from aTable where StringField in ('string1', 'string2')

works fine, however

select * from aTable where StringField in ('string1', 'string2')
and AnyField = 0

does not work. In fact anything you do beside the 'IN' selection breaks the SQL statement.

Couple of things i concluded:

- The bug seems to be dBExpress only, BDE or SQL+ clients process it fine
- The bug is also present using the SQLDriver, it is not database dependend