MS Access LIKE condition returns zero records

[BillMe]

When using the "WHERE" clause with the "LIKE" condition with the database connectivity toolkit, I get zero records returned from my Access database. Running the exact same query text in MS Access itself returns the correct number of records.

I'm using the "DB Open:", DB Execute Query" and then the "Fetch Recordset Data" VIs.

Replacing the LIKE with a simple "=" will return the one matching record as expected.

Is there a known issue using the "LIKE" condition?

Bill

LabVIEW 2011 SP1

[Matthew_Kelton · Accepted solution]

While old, this may shed some light:

http://forums.devarticles.com/microsoft-access-development-49/like-operator-not-working-with-ms-acce...

Your LIKE statement may not be properly formed.  Insida Access, the connection is different than through ODBC, and the like wildcards are different as well.

[BillMe]

You are correct. The wildcard character is different for ODBC, should be '%'. Thanks.