Ben,

> Thanks for your reply.
>
> I am using only 'GLAX%', sString can be 'G%' or 'GL%' or
> 'GLA%', the plan tab in IBConsole shows it is using index.

So the query should be fast enough. Is there any other problem
with the LIKE clause?


Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com