Subject RE: [firebird-support] Why this query doesn't work?
Author Leyne, Sean
Fabiano,


> select
> *
> from
> table1
> where
> udf_digits(table1.code) like udf_digits(:code)

1) Are you sure that you want to use the "LIKE" operator?

2) Did you try:

select
*
from
table1
where
udf_digits(table1.code) like (udf_digits(:code) || '%')


Sean