Using Delphi 6 (Enterprise).
I've set up a form to display a paradox .db file called Sls_cont.
This form has a variety of fields (ex. company name, contact,
telephone #, address, notes, etc.) My question is how do I go about
setting up a search procedure. Say for the company name field, I've
got a search button, and would be looking for strings, but I want to
have a wildcard..so that the user can search for just the first
letter or two letters of the name, a middle letter, or the end
letter. Thanks in advance.

--
Posted via http://dbforums.com

You haven't specified what kinda database connection you are using.. anyway,
I am assuming here that you may be using SQL statement to access data. So
the statement should be

" Select * from TABLE where (TABLE.FIELD like 'A*' "
This will select all records from TABLE with FIELD value starting with "A"


"epicurean" <member30259 (AT) dbforums (DOT) com> wrote