Zeoslib Portal

dtmMain->qryProductos->Filter = "Upper(" + sColName + ") like "+ QuotedStr("%"+ AnsiUpperCase(sText)+"%");
dtmMain->qryProductos->Filter = sColName + " = "+ AnsiUpperCase(sText);

That not working. qryProductos is a TZQuery connected to a TZConnection with a SQLite database.

Always the result for that filter is the empty dataset.
why?

Use * instead of %.

Regards,

Ben

The '_' is '?' ??

% == *
_ == ?

Thanks Ben