Filter and Filtered propertyes

[CID]

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?

[btrewern]

Use * instead of %.

Regards,

Ben

[CID]

The '_' is '?' ??

[CID]

% == *
_ == ?

Thanks Ben