how to search (filter) substrings using a query component in a BDE database?
Posted on 2007-04-03
I have a BDE database with three fields: two memos and one string field. I want to searchand filter the string field to find partial strings. I mean, I want to filter the database (and to see the results in a dbgrid who is present in my form) if I search for the string "nd". The system should show me the records with this specific field 'nd', for instance 'random' or 'and', but hide records with 'hello' string...
I tried this:
Query1.Sql.Add('select * from database where field like '+QuotedStr('%'+SearchStr+'%'));
but it didnt work...Any ideas what I am doing wrong? Should I have the string field indexed?