TCRDBGrid Component --> filter/search CONTAINS?

[achung]

Hello -
In TCRDBGrid, is there a way to express CONTAINS as the relational statement?
In other words, in the column filter/search bars of the grid, is it possible to execute:
(1) Last Name CONTAINS "mit" to return "Smith"? The default behavior of the search bars appears to return "Smith" only if the user enters "Smi..." (i.e. Last Name STARTWITH...)

Thanks.
Andrew

[AlexP]

Hello,

You can use the '%' symbol in the filter to specify any number of any symbols, similarly to the LIKE operator: %mit% -> Smith