Subject | RE: [firebird-support] Why this query doesn't work? |
---|---|
Author | Leyne, Sean |
Post date | 2005-07-11T18:18:34Z |
Fabiano,
2) Did you try:
select
*
from
table1
where
udf_digits(table1.code) like (udf_digits(:code) || '%')
Sean
> select1) Are you sure that you want to use the "LIKE" operator?
> *
> from
> table1
> where
> udf_digits(table1.code) like udf_digits(:code)
2) Did you try:
select
*
from
table1
where
udf_digits(table1.code) like (udf_digits(:code) || '%')
Sean