Subject Re: [firebird-support] LIKE clause trough ODBC: expression evaluation not supported (SOLVED!)
Author Mimmo
<snip>

> SELECT
> Tbl1.Fld1 AS t1xxx,
> Tbl1.Fld2 AS t1yyy,
> Tbl2.Fld3 AS t2zzz,
> Tbl2.Fld4 AS t2kkk
> FROM Tbl1, Tbl2
> WHERE Tbl1.Fld1 = Tbl2.Fld1
> AND ( Tbl2.Test1 = 'N' OR Tbl2.Test2 = 'P')
> AND Fld3 LIKE ? + '%'
> ORDER BY Fld3

After sending previous e-mail, immediatly suspected that my ODBC docs
(3.0) maybe obsolete.
I've found in the code a small segment that parse every query, and
sobstitutes " || " in " + ". Commenting that code solved the problem.

Many thanks, anyway.

Mimmo.