Figure 3. Use the LIKE Predicate With Wildcards for Partial Matches
A dropdown list displays the results of partial-match searches that return more than one DataSet row. A ZIP code search of 25,000 to 50,000 records with the default ZIPCode LIKE 75020 criterion fills the list with selections shown here in less than 48 ms. Searches on the CustID primary key take less than 16 ms. Selecting a record enables an Edit Row button that's hidden under the list items control.