|Subject||RE: [firebird-support] Re: Problem with : where name like '%to'|
> It's a solution for toto, but with this query I want all person withLIKE works for me.
> 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 ?
Have you tried
WHERE UPPER(NAME) LIKE "%TO"