Devart Forums

I prefer to use filtering on local dataset - not to call query and
request data again from SQL server.
With fileds of 'numbers' types it is usually without problems.
But when it comes to text/varchar its more complex to support
local filtering in CASE-insensitive mode and even using LIKE statement.
Is it possible to apply local filtering on your LocalDataset (query
component) using statement "customer LIKE '%ro%'" returning records
containing 'Roman' as well as 'Carol' in customer field?

Thanks

Hello,
To enable case insensitive filtering by text fields, you need to set the foCaseInsensitive option under FilterOptions to True. For example: wbr, Oleg
Devart Team