i tried 'like' before but defining my own escape sequence since i
can't guarantee that my sring doesn't contain wildcards:

for select first 20 id from dicentries where asterm like '\' || :term
|| '\' escape '\'

and id > :idin order by id ascending into :id do
suspend;

but here i get an invalid escape sequence error!

--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> > 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/
>