Just for curiosity, i tried this having only 1000 records instead of 3553 in
the tables CLIENTES. :
select first 20 * from LISTA_CLIENTES where (CLIENTE like 'crist%'
or MORADA like 'crist%' or LOCALIDADE like 'crist%' or CLIENTE like
'crist%' or PAIS like 'crist%' or PAIS_NOME like
On Thu, Jul 12, 2012 at 9:33 AM, peixinhosdalua peixinhosda...@yahoo.comwrote:
In this case, the goal is to make '%word%' not 'word%'. In understand your
suggestion but it is not what i need to achieve.
Firebird cannot use an index on partial word matches unless it knows the
initial
