🚀 go-pugleaf

On Sat, 3 Aug 2002 23:15:15 +0800, "HuangC" <akeehuang@163.net> wrote:

>I'm using MS Access database.

I can confirm that using 
    
    LIKE '%something%'

with JET OleDb databases works like a charm.

I've tried with the database coming with BCB and ADOExpress components:
I've used a TADOConnection and a TADODataSet. Providing the ADOConnection with
the following ConnectionString  

ConnectionString = 
    "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;"
    "Data Source=C:\\Program Files\\Common Files\\Borland "
      "Shared\\Data\\bcdemos.mdb;"
    "Mode=Share Deny None;Extended Properties=\"\";"
    "Jet OLEDB:System database=\"\";"
    "Jet OLEDB:Registry Path=\"\";"
    "Jet OLEDB:Database Password=\"\";"
    "Jet OLEDB:Engine Type=5;"
    "Jet OLEDB:Database Locking Mode=1;"
    "Jet OLEDB:Global Partial Bulk Ops=2;"
    "Jet OLEDB:Global Bulk Transactions=1;"
    "Jet OLEDB:New Database Password=\"\";"
    "Jet OLEDB:Create System Database=False;"
    "Jet OLEDB:Encrypt Database=False;"
    "Jet OLEDB:Don't Copy Locale on Compact=False;"
    "Jet OLEDB:Compact Without Replica Repair=False;"
    "Jet OLEDB:SFP=False";

then filling the TAdoDataSet's CommandText property with the following
statement

    SELECT FirstName
    FROM employee
    WHERE FirstName LIKE '%er%'

I can be able to obtain the following relation:

 +-----------------------------+
 | FIRSTNAME                   |
 +-----------------------------+
 | Roberto                     |
 | Terri                       |
 | Katherine                   |
 | Roger                       |
 | Roger                       |
 | Walter                      |
 | Jennifer M.                 |
 | Oliver H.                   |
 | Roberto                     |
 | Pierre                      |
 +-----------------------------+

that is

 +-----------------------------+
 | FIRSTNAME                   |
 +-----------------------------+
 | Rob[er]to                   |
 | T[er]ri                     |
 | Kath[er]ine                 |
 | Rog[er]                     |
 | Rog[er]                     |
 | Walt[er]                    |
 | Jennif[er] M.               |
 | Oliv[er] H.                 |
 | Rob[er]to                   |
 | Pi[er]re                    |
 +-----------------------------+

Good Luck.

Ciao!

Giuliano