fb_cse 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 ?

Because the field is padded with spaces, so it doesn't actually finish
with 'to' but with 'to ' for example.

You can use something like this:
where name like '%to %'

Not very nice, but it should work.
AFAIK, if you change column datatype to VARCHAR, then you can use the
'%to' without problems.

--
Milan Babuskov
http://fbexport.sourceforge.net