Devart Forums

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

Hello,

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