Hi Jeff,

> That is if there is an event that fires before the actual
> search, so that the input criteria can be parsed and
> replaced with the correct syntax. I know there is an
> aftersearch event of the TIB_Query, but I'm not sure if
> this fires before performing the search. My question is,
> is the aftersearch event appropriate for this purpose?
> (Can only test not until midnigt today).

My suggestion (something I have used to great effect) is the
the IB_Connection.OnProcessSearchBuffer event.

If you take a look in IB_Parse.pas at the ExtractWhereClause
procedure you will see where many of the "smarts" occur for
processing search inputs. This can make a useful reference
for writing your own search processing. In that procedure
you can see at the top where the connection event is called
to allow you to override it. Just set "DefaultHandling"
to false for those things you have taken care of yourself.

--
Geoff Worboys
Telesis Computing