Rajesh Punjabi wrote:

>
> Is there any way to directly optimize blob search that anyone here can
> point me to ?

Searching for arbitrary strings in varchars won't help either. What
you need is a full text search ... there are several choices.

http://www.ibobjects.com/ibofts.html
http://www.codeproject.com/cs/database/FulltextFirebird.asp
http://www.textolution.com/ftsib.asp

And probably more...


Best,


Ann