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
>
>
>