> If you want to modify the WHERE clause of a query, then use the
> SQLWhereItems property to easily modify the WHERE clause. And, I normally
> do this within the OnPrepareSQL event.

If you are using the SQLWhereItems property anywhere other than the
OnPrepareSQL event then you are misusing it. This is the only place where
this property is used correctly.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com