>I don't know if it helps but I got round it by using a TIBOQuery and
>using the SQL property direct, ignoring the 'Where', 'Insert' etc.
>SQL properties. That way I have full control. It seems to work fine,
>no idea whether or not it is best practice though.

I use SQLWhere.Add(...), and not SQLWhereItems. And it's all ok.

Sergio