> > 1) Are you sure that you want to use the "LIKE" operator?
>
> Yes
>
> > 2) Did you try:
> >
> > select
> > *
> > from
> > table1
> > where
> > udf_digits(table1.code) like (udf_digits(:code) || '%')
> >
>
> Yes, it was my original query (with the '%' outside the parenthesis).
> I just simplified it to post to the support list. It doesn't work
> also.
>
> where
> udf_digits(table1.code) like (udf_digits(:code)) || '%'
>
> Maybe it's some limitation that prevents the query below to work, too:
>
> select * from rdb$database
> where
> cast(:a as integer) = cast(:b as integer)

What version are you running?


Sean