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%'.