> i have an sp, that looks like the following:
>
> begin
> for select first 20 id from dicentries where asabbildung containing
> :term
> and id > :idin order by id ascending into :id do
> suspend;
> end
>
> as it turns out, the default behaviour seems to be that case is being
> ignored when using "containing"..how can i disable that?

1) WHERE asabbildung LIKE '%' || :term || '%'

it expects that term does not containt wildcards ('%', '_')


2) WHERE CAST(asabbildung AS VARCHAR(...) CHARACTER SET OCTETS) CONTAINING :term

Ivan
http://www.volny.cz/iprenosil/interbase/