> Is there a function I can call to to turn a TStings containing 'where

items' in SQLWhereitems format into SQLWhere strings?

Not that I can think of. It is done internally by IBO. I could possibly make
the code accessible somehow. Of course you can get in under the hood and do
that too if you want. <g> I'd merge in the changes for you.

> Why?
>
> Well - I often find I am calling a routine which will create a form, set

up a query and display the results. The call includes various parameters.
I want to construct the where clause using the parameters, but I would
rather not have to create form variables for each parameter so I can pass
them through to the OnPrepareSQL event, or write the code to manage the
wheres and ands, when it may already exist.

>
> Might it be a useful future enhancement to make the SQLWhereItems persist

outside the OnPrepareSQL event?

I suggest you use your own sub-class and have a property you use to start
the OnSQLPrepare event by dumping its contents in there. This effectively
would be the same thing.

Jason