--- In firebird-support@yahoogroups.com, "Svein Erling"
<svein.erling.tysvaer@k...> wrote:

> > select distinct '"' || name || '"' from person where name like
> > 'toto';
>
> Sorry, I meant
>
> select distinct '"' || name || '"' from person where name containing
> 'toto';

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 ?