Zeoslib Portal

Can nobody help me? Am I the only one with these filter problems?

Problem 1: This filter works: fieldname like "value*" This filter does not work: fieldname like "*value*" What am I doing wrong here? Problem 2: I have the following sql loaded in the TzQuery: SELECT.. table1.name, table2.name,.. FROM ... INNER JOIN table1.. table2 Works fine, b...