I am making a filter for my sqlite table using this formula. All goes well, but it is very sensitive to uppercase and lowercase letters. How to be insensitive with upper and lower case letters?
fdtableTab1Edit.Active := true;
fdtableTab1Edit.Filtered := false;
fdtableTab1Edit.Filter := 'PRODUCK like ' +
QuotedStr('%'+edit1.text+'%')+' or CODE like ' +
QuotedStr('%'+edit1.text+'%')+' or TOTAL like ' +
QuotedStr('%'+edit1.text+'%');
fdtableTab1Edit.filtered := true;
fdtableTab1Edit.Refresh;
Edit1.Text := '';
Set FilterOptions
to do case insensitive comparisons instead of the default case sensitive.
fdtableTab1Edit.FilterOptions := [foCaseInsensitive];