> 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