If the set that word belongs to is small and fixed, you could index on a function. If it is unbounded, you're pretty much going to have to look into something that does full text indexing (e.g., Lucene).
On 7/13/2012 8:57 AM, peixinhosdalua wrote: > What you suggest is not a solution because just using the tables CLIENTES, > without any join or inside a view, the problem remains. I tried it. > > Also, i do not want to make 'word%' search. What i need is '%word%'. > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > >