>m.texto="%"+UPPER(alltrim(thisform.pageframe1.page1.pageframe1.page5.text1.value))+"%"
>if empty(m.texto)
> =messagebox("please type something")
> else
> select llamadas.detalle as problema, llamadas.solucion as detalle;
> from llamadas;
> where UPPER(llamadas.detalle) like m.texto ;
> and llamadas.bdc = .t. ;
> into cursor bcproblemas3
> report form bcinforme.frx preview
>endif
>
>
>Just understand that the query will take a little longer(*) unless you have and index on UPPER(detalle)
>
>(*) shouldn't be noticable (unless you have an index on detalle)
The original query and new one aren't optimazable because of the '%' at the beginning of m.texto. So creating index on llamadas.detalle or UPPER(llamadas.detalle) wouldn't help.
--sb--