Subject Re: [firebird-support] Re: Problem with : where name like '%to'
Author Milan Babuskov
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