--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > It's a solution for toto, but with this query I want all person

with

> > name ending by 'to'. For my example query result is toto but it

could

> > be other several names ending by 'to'.
> >
> > So why "where name like '%to';" it's no good with firebird ?
> >
>
> LIKE works for me.
> Have you tried
> WHERE UPPER(NAME) LIKE "%TO"
>
> Alan

I try your solution but it's not ok.
I've got Firebird 1.5 RC 7 for Win32 and you ?