title: Delphi XE10 Filtering database table using FORMAT LIKE
body: <p>I want filtering my database using fdtable. I write this code fdtable2.Filter := Format('PRODUK LIKE ''%s%%''', [edit1.Text]); but it was so sensitive with Uppercase and Lowercase. How can i write the code so when i write 'emon' in the edit.text, it filtering the word like 'Lemon' into the database. Thank you</p>